Syntax for Countnig Rows

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

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.
 
Hi
try
NumRowsB = Workbooks("B.xls").Worksheets("Xwalk").Cells(Rows.Count,
"A").End(xlUp).row
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing Dynamic Range 2
Copy a table from one workbook to ALL worksheets in a different wb 1
AutoFilter Criteria using named range 4
Triming trailing spaces before using Match on columns of numbers withleading zeroes formatted as tex 1
Open four Wbooks, copy four columns from each to Master Wbook 16
macro required.. 1
DAO Syntax Problem 12
Workbook looping to many worksheets 3

Back
Top