-
Changes formula to value- wrong number format
This line changes the formula to a value I need for subsequent operations, however it changes a fraction 1/8 to a date of 8-Jan. I need it to remain 1/8.
[vba]
.Range("M4:M" & LRowV).Formula = .Range("M4:M" & LRowV).Value
[/vba]
Hopefully a simple fix...
Thanks.... (sorry for hitting the board so much, trying to finish this one piece)
my site: www.ecboardco.com
was built w/ a majority of the assistance from the board members here... thanks VBAX.
Just because I see something, doesn't mean that what's actually happening is what I see.
You don't get from 0-90 by standing still!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules