I feel like an idiot for not being able to figure this out. I want to change the number of decimal places to 2 for a few cell references. My code:
It's telling me it expects an = sign. What am I doing wrong?
Round(Range("B:" & (q + 2)).Value, 2)
Considering the complexity of my macro I can't even figure out something as simple as this.
Thanks for your help!
Last edited by kenab1; 03-08-2010 at 01:32 PM.
Try this
somevar = Round(Range("B:" & (q + 2)).Value, 2)
Ok got rid of the = sign issue but it's still giving me an error at that point. Thanks though.
Ok I figured out a way to do it. The following code:
It's Monday morning. Brain no worky.somevar = Cells(q + 2, 2).Value r1 = Round(somevar, 2) Cells(q + 2, 2).Value = r1
Just noticed
Trysomevar = Round(Range("B:" & (q + 2)).Value, 2)
Delete ":"somevar = Round(Range("B" & (q + 2)).Value, 2)
sorry I missed that first time round
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks