View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] HSNYDER313@COX.NET is offline
external usenet poster
 
Posts: 2
Default 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