Related:
- Variable range graph
- Apple airtag range - Guide
- How to create a graph in word - Guide
- Wimax frequency range - Guide
- Excel take screenshot of range - Guide
- My documents variable - Guide
4 responses
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jun 30, 2009 at 06:17 AM
Jun 30, 2009 at 06:17 AM
Hi rukid
Instead of Range(n, f) use Range("A5:D" & n)
Instead of Range(n, f) use Range("A5:D" & n)
Hey thank you for the reply,
I tried what you suggested but it does not work as the columns that the data are in are not from a through d continuously, they are in a,d,f,h,j do you know of a remedy for this? Thank you again.
I tried what you suggested but it does not work as the columns that the data are in are not from a through d continuously, they are in a,d,f,h,j do you know of a remedy for this? Thank you again.
The other issue that I just noticed is that if I change the length of the data meaning make the columns have more or less data, the macro does not change the range to encompass the whole column. Thanks for any help.