Range selection in macro

[excellearner121]

HI All,

Here is my recorded macro.

Please Login or Register  to view this content.

I was wondering if I can remove the H2:H17323 and have something like H2:H & Lastrow
also for I2:I17823. there are alot of ranges like these in the complete macro.

THANKS
KIND REGARDS

[TMS]

Something like:

Please Login or Register  to view this content.

Regards, TMS

[excellearner121]

HI TMSHUCKS thanks alot. I was wondering if we were to do filter after vlookup on column H,
remove some rows and concatanate column I will it still pick the changed range of 1LR after filtering.

[TMS]

That code finds the last row depending on the values in column A. That was chosen arbitrarily because it is quite often the key field on a data sheet.

However, if the bottom rows are hidden, they will be ignored, so the results could be misleading.

If the last row is visible, it doesn't matter how many intermediate rows are hidden.

If you filtered and removed some rows and either turned the filter off or the last row was visible, you'd need to run that line of code again to refresh the value.

Maybe you should experiment to see what you get.

Use

Please Login or Register  to view this content.

in the Immediate Window to quickly check the effects of filtering, particularly if the last row(s) are hidden.


Regards, TMS

Regards, TMS