Changing thr range in VBA

[PANV]

Hello
Was searching for a solution on google. Found one but need help
in vba since I know only basic formula level.
The existing range reads only second column.
I require to change it to A1:Z5000 with actual values
since formula involved in some columns.
How to do?

Thanks

Please Login or Register  to view this content.

[alansidman]

Change this line of code

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

if I am understanding your request.

[Richard Buttrey]

Hi,

I'l admit I may not fully understand your request which is why we generally prefer to see a workbook which shows a Before and After situation
However, that said and if this is a question about converting formulae to values, which I imply from your OP perhaps...

Please Login or Register  to view this content.

[PANV]

Hi
I checked and found both the options are workable.
However would first prefer the first one.
Thanks alansidman and Richard Buttery.