| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to Resize a variable number of rows including target
I have the ?? hard coded in my macro but sometimes the number of rows to include vary.
I know I have hit all around it but can't nail the proper xldown.rows.count or Rows.Count).End(xlUp)scheme to replace the ??. I thought for sure I would have it in my cheat-sheet but... If Not aCell Is Nothing Then aCell.Resize(??, 1).Copy Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp)(2) End If Thanks, Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| variable number of rows. | Excel Programming | |||
| Create a production v's target report in excel including graphs | Excel Discussion (Misc queries) | |||
| Get number of rows that data uses, including blank rows | Excel Discussion (Misc queries) | |||
| Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
| Including a variable number of columns in Excel Sum formula | Excel Programming | |||
Threaded Mode
