VBA CurrentRegion Extend

[timmah]

I have a annoying problem here. I already solved it once, but somehow I lost the code and I can't remember how I did it before.

Here is my problem, I have a block of data, and then four columns over I have another row of data. I select the CurrentRegion using VBA, then I want to expand the range to go over four columns. I do not want the rows selected to change, just the columns.

Any help would be welcome.

Thanks,

Timmah

 

[Barrie Davidson]

If I understand what you're asking, try

Selection.Resize(, Selection.Columns.Count + 4).Select

 

[timmah]

That worked, Thank you. That wasn't how I did it before but it works.

:>