I need to select a range of cells for copying/pasting
opperations but the range changes everytime new data is
imported into the worksheet. The 2 columns remain the
same but the rows vary. I can calculate the upper left
row number and store that value in a specific cell
location and likewise I can calculate the bottom right
row number and store that value in another specific cell
location, but I don't know how to write the macro code to
assign the values. ex: [range("BA$:CX#").select]
(where "$"= the value in cell AY1 and "#"= the value in
cell AY2. It probably is very simple but I keep getting
syntax errors.