Related:
- Copy row to next available row in another wb
- Saints row 2 cheats - Guide
- How to delete a row in word - Guide
- Saints row pc download - Download - Action and adventure
- How to repeat rows in excel - Guide
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - 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