Discussion of Forex Trading and Currency Trading

Excel VBA: Currency formatting with object variables and "offset" property?

I get an object defined error. What is wrong with this line of code? Findrate is a range variable.

Sheets(1).Range("findRate.Offset(1, 0)").Style = "Currency"

Most Commented Posts

 

 

One Response to “Excel VBA: Currency formatting with object variables and "offset" property?”

  1. findRate.Offset(1, 0).Style = "Currency"

Leave a Reply