Related:
- Copy row to next available row in another wb
- Saints row 2 cheats - Guide
- How to delete a row in a table in word - Guide
- Saints row free download - Download - Action and adventure
- Vba last non empty row - Guide
- Vba change row color - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Mar 7, 2011 at 01:01 AM
Mar 7, 2011 at 01:01 AM
quote
nxtRw = Workbooks("Tooling Master Sheet.xlsx").Sheets("Sheet1").Range("C" & Rows.Count).End(xlUp).Row + 1
rows shod come first and columns later
it should be
range(rows.count,"C").end(xlup).row+1
nxtRw = Workbooks("Tooling Master Sheet.xlsx").Sheets("Sheet1").Range("C" & Rows.Count).End(xlUp).Row + 1
rows shod come first and columns later
it should be
range(rows.count,"C").end(xlup).row+1