Syntax for Countnig Rows
Within a macro in workbook A I am trying to get the row
count in a worksheet named "Xwalk" in workbook B. I can't
figure out the syntax.
This doesn't work:
NumRowsB = Workbooks("B.xls").Worksheets("Xwalk")!Range
("A1").End(xlDown).Row
Can someone please correct for me.
Thanks.
|