use xlup and offset in a range of cells

B

Bill W W

Every week i get a new spreadsheet with a new number of rows based o
current data. I need to set some filters in that spreadsheet and the
copy the remaining data in that column. i need to use the results of th
very last row with data as a variable and then substitute it into
range.select statement so i don't have to change the range every time
run the macro, it would be set for me using xlup and offset. I'm sur
this can be done i just can't seem to get the syntax right. Pleas
Advise.. Thank
 
G

GS

Every week i get a new spreadsheet with a new number of rows based on
current data. I need to set some filters in that spreadsheet and then
copy the remaining data in that column. i need to use the results of
the very last row with data as a variable and then substitute it into
a range.select statement so i don't have to change the range every
time i run the macro, it would be set for me using xlup and offset.
I'm sure this can be done i just can't seem to get the syntax right.
Please Advise.. Thanks
Click to expand...

It would be easier to help you if you post your code...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Max value within a Offset 2
Word macro that can call cells out of Excel for a find and replace 0
VBA to see if a Section exists in Word Document, and if it does, delete it 2
How to use/create code in MS Word to calculate age? 0
Need Help with a VBA subroutine 0
Dealing with a Pivot Table (when I don't want to) 0
Creating a Chart on form from selected data in query. 0
Range("a21") .end(xlDown) or .end(xlUp) . offset(1,0) . value 1

Top