| 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... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
for x to - next x question
Try this.
If this helps click Yes -------------- Jacob Skaria 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
for x to - next x question
Hi,
You have a syntax error, try this 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 Mike "EXCELMACROS" wrote: 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... |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
for x to - next x question
Hi
Look at the placement of -1 in the parantheses: Range("G" & x) = Right(Range("F" & x), Len(Range("F" & x)) - 1) Range("I" & x) = Right(Range("H" & x), Len(Range("H" & x)) - 1) Regards, Per "EXCELMACROS" skrev i meddelelsen ... 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... |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
for x to - next x question
thanks for catching my error however, when I run it, it partially works, let
me show you: 300 300 500 500 2.200 2.2 300 300 200 200 you can copy paste that..., all my values work but the " 2.200" is returning "2.2" why is that? -- Thank you... "Mike H" wrote: Hi, You have a syntax error, try this 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 Mike "EXCELMACROS" wrote: 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... |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
for x to - next x question
PLEASE IGNORE my last comment, very stupid from my end, it is working
perfectly. -- Thank you... "EXCELMACROS" wrote: thanks for catching my error however, when I run it, it partially works, let me show you: 300 300 500 500 2.200 2.2 300 300 200 200 you can copy paste that..., all my values work but the " 2.200" is returning "2.2" why is that? -- Thank you... "Mike H" wrote: Hi, You have a syntax error, try this 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 Mike "EXCELMACROS" wrote: 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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
