Greetings,
I would like to convert the cell formula into a value without using copy/paste. My code is using the copy/special paste method.
Please Login or Register to view this content.
Greetings,
I would like to convert the cell formula into a value without using copy/paste. My code is using the copy/special paste method.
Please Login or Register to view this content.
Try
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
TMS,
WOW it was soooooo simple. Thank you MUCH for pointing me in the right direction!! I changed your code a bit.
Please Login or Register to view this content.
You're welcome. Thanks for the rep.
You don't need your amendment. It will work as described ... .Value = .Value
The dot links the Value property to the range specified in the With statement in both cases
You could however say
And then you don't need to use the With ... End With constructPlease Login or Register to view this content.
TMS,
Yep, that worked as well!
Thank you VERY much for this bit of info. I will NEVER use copy/paste again!!!!
Again, you're welcome.
The With ... End With construct is used for brevity and efficiency.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks