Macro to change cell format

[ste33uka]

Hi would anyone have a macro that would change cell format ?
I would like cells (u5:v99999) and (x5:z99999) to text format
and
cell (w5:w99999) to number format.
Thanks

 

[Joe4]

If you turn on your Macro Recorder, and record yourself doing this manually, you will easily get the VBA code that you need.
The Macro Recorder is a very valuable tool to use to get snippets of code like this!

 

[Fluff]

Why not just record a macro of you applying the formats manually. Then you have the code.

 

[ste33uka]

Why not just record a macro of you applying the formats manually. Then you have the code.

Never knew i could do that, i will give it a go, thanks

 

[Fluff]

Any problems, just post back.

 

[ste33uka]

Thanks alot , think its done and thanks for tip about recording macro, might use that alot more.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Joe4]

I am guessing that you missed the first reply, in which I told you to do this exact thing!

 

[ste33uka]

If you turn on your Macro Recorder, and record yourself doing this manually, you will easily get the VBA code that you need.
The Macro Recorder is a very valuable tool to use to get snippets of code like this!

Thanks to joe, sorry i missed your post somehow, thanks

 

[Joe4]

Thanks to joe, sorry i missed your post somehow, thanks

I think sometimes people have tendency to go right to the last reply, instead of looking at all the replies.