remove white spaces in a specific column

[stoey]

hi everyone,

i saw this code from Ron and it remove whitespaces

Please Login or Register  to view this content.

i am trying to tweak the code to fit my need because I would like to make this code work for column i only like i2:i63350 ...anybody can help me how to accomplish this?

thanks,

josh

[alansidman]

Try this:

Please Login or Register  to view this content.

[HaHoBe]

Hi, stoey,

you could try and apply an Autofilter and delete all the visible cells (if any) by using SpecialCells(xlCellTypeVisible) - please make sure to check if there are any cells of that type before running the command in order to avoid a run-time error.

Ciao,
Holger

[stnkynts]

Well for starters you would need to remove the apostrophes before each line. Then you could do something like this:

Please Login or Register  to view this content.

[stoey]

hi again,

thanks for the quick response: alan, haho and stnk....i very much appreciate your answers. Here's the thing..I get to try alan and stnk resolution and it worked well..however, i don't get hahobe's approach...probably you can give me a sample vba on how to do this...thanks a lot..you guys rock

[HaHoBe]

Hi, stoey,

if you understodd the basics of this you might try and record a macro via Macro-Recorder to get the basic code which needs to be worked on which may result in a code like this:

Please Login or Register  to view this content.

Ciao,
Holger