How do you program "do this to the range of cells selec

[colmmc]

.....into a macro? It's probably really obvious but I cant work it out.

 

[colmmc]

Re: How do you program "do this to the range of cells s

Apologies for the messed up title.

I'm trying to set up some text cleaning macros that can be applied to any rance of cells but I dont know how to get it progammed to be applied to any range selected. I need it to be flexible so that I can clean up various sized tables.

 

[jamespotter]

Re: How do you program "do this to the range of cells s

Will the "selection" statement do? It works on whichever cells are currently selected.
E.g.

With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With

 

[onlyadrafter]

Re: How do you program "do this to the range of cells s

Hello,

This will clear the contents of the selected cells

Sub do_this()
With Selection
 .ClearContents
End With
End Sub

 

[colmmc]

Re: How do you program "do this to the range of cells s

OK, I'll give it a go.

Thanks

 

[colmmc]

I'm not clearing contents, I'm cleaning up the data, removing trainling spaces, removing underscore, separating text, etc.

Thanks.