Related:
- Copy row to next available row in another wb
- How to delete row in word - Guide
- Saints row 2 cheats - Guide
- Excel create unique id for each row ✓ - Excel Forum
- Move row to another sheet based on cell value ✓ - Excel Forum
- Excel duplicate each row x times ✓ - Excel Forum
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