| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I change range name definitions as the No. of rows change.
I import data from an accounting application. The columns are always
fixed at 7.. The number of rows will vary. 3 ranges are used in functions and a pivot tables. ABC A1.C1 down to last row. AtoG A1. G1 down to last row FG F1.G1 down to last row. The last row is the same for all 3 ranges. Can anyone suggest the VBA code needed to accomplish this. I know very little aboutr VBA . I just know enough to copy and paste new code into code compiled by recording a macro.- Thanks, Harvey Snyder Providence, RI |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
| Trouble with 2 range definitions ... | Excel Programming | |||
| excel deleting rows last cell does not change. How to change? | Excel Discussion (Misc queries) | |||
| Change Rows/Columns in range??? | Excel Programming | |||
| Change Rows/Columns in range??? | Excel Programming | |||
Threaded Mode
