| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
for x to - next x question
hi, could someone see what's the problem with the following:
For x = 2 To lastrow Range("G" & x) = Right(Range("F" & x), Len(Range("F" & x) - 1)) Range("I" & x) = Right(Range("H" & x), Len(Range("H" & x) - 1)) Next x I just want it to see the previous cell and take one blank space out of the way. (trim does not work, i.e. " 3.5" and I need "3.5") -- Thank you... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Threaded Mode
