Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting cells loop
I have some numbers in column G that are formatted as general but newly
pasted text into the column doesnt seem to pick up the destination formatting, even after formatting the selection. (I know this because it distinguishes between it in a pivot table). It seems I need to go through each cell and double click at the end of the text. Is there are way to do this programatically? I figured if I recorded a macro doing it in one cell then amending the code to go through the column? I've never used a loop before so would appreciate any advice. The range of cells is called SPECIALTY. TIA -Ciara |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting in For:Next loop - won't work!!! | Excel Programming | |||
VBA Loop Formatting Text Question | Excel Programming | |||
Conditional Formatting in a Loop | Excel Programming | |||
conditional formatting & a loop | Excel Programming | |||
Loop for changing cell formatting | Excel Programming |