常用宏

 

'查找当前表最末行行号。a65536中的a代表查找最末数据的所在列,可修改成诸如b,c,d等'
ActiveSheet.Range("a65536").End(xlUp).Row    

'引用Excel公式。如引用最大值公式'
Application.WorksheetFunction.Max(1,2)
 Posted by at 00:20

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)