Thread
:
Select range -- convert formulas to values
View Single Post
#
1
Posted to microsoft.public.excel.programming
Johnny[_9_]
external usenet poster
Posts: 8
Select range -- convert formulas to values
I understand how to convert a formula to a value:
Range("A1").Formula = Range("A1").Value
Can somebody help with the syntax to use the selected range instead of
hard-coding a range into the macro?
Reply With Quote
Johnny[_9_]
View Public Profile
Find all posts by Johnny[_9_]
Select range -- convert formulas to values