Delete cell content if find a space in relative cell reference

[kent97]

Dear all,

The Sub below find all the space in column C and delete the cell contents. How can I rewrite it in relative cell reference so that column C deleted when this Sub starts at cell A1, or space in column G deleted when this Sub starts at E1 etc....

thank you

Please Login or Register  to view this content.

[stnkynts]

I am having a hard time understanding all the parameters you have described. Do you want to delete just the spaces from a string within a cells (i.e. this string to thisstring) or do you want to clear the entire cell if there is any space anywhere? Or are you trying to remove spaces at the front and rear? Or are you trying to remove spaces in a blank cell?

Also, please clarify your column C, A1, column G, E1. It is not clear.

[kent97]

Thank you for your reply stnkynts.

1. I want to clear the entire cell.
2. I want to rewrite the Sub from absolute cell reference to relative cell reference.

[stnkynts]

That is about as clear as mud. Could you submit an example workbook with before and after expectations.

[kent97]

Dear stnkynts

File Attached for your reference.

[stnkynts]

No file. Use "Go Advanced"

[kent97]

File attached please...

kent