Home |
Search |
Today's Posts |
#1
|
|||
|
|||
cells() and counting number or rows on spreadsheet
I was just curious I have done this in excel with a macro I created and it
works just fine so now I am in word and trying to create this macro which is supposed to open excel and then I am doing some excel programming in it I look for the last row using this lstrow = cells(rows.count, "A").End(XlUp).row and it tells me it doesn't understand the cells(). Is this because it's in a macro that I am creating in Word??Am I wrong in assuming that with the VB editor it shouldn't matter what application you are in?? Any help or suggestions is appreciated. Thanks, Heather |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting cells with conditional formatting applied | Excel Discussion (Misc queries) | |||
counting text cells | Excel Worksheet Functions | |||
Count number of shaded cells | Excel Discussion (Misc queries) | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions |