Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I wonder if you could help with a small macro - On sheet1 of my workbook I have a rectangle in cell A2 and I need to assign a macro to it that would do the following. Range I2:I200 any number found in the range would automatically change to the letter A. Range J2:J200 the same as above the letter to be B. Range K2:K200 the same as above the letter to be C. Range L2:L200 the same as above the letter to be D. Range M2:M200 the same as above the letter to be E. Range N2:N200 the same as above the letter to be F. Range O2:O200 the same as above the letter to be G. There are blank cells in all the ranges. -- Many Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using TEXT and &TEXT - display numbers with commas, underline text | Excel Discussion (Misc queries) | |||
VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) |