Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easy but not for me!!
Hi I recieved a reply from Bob Phillips AND Tom Ogilvy
regarding a question I had on formatting of cells on my sheet. I would like to use the following code to specify that the cells D6:D26 will always have the format of number and 2 decimal places. If ActiveCell.Numberformat = "0.00" or Activecell.Numberformat = "#,###.00" Can you tell me how to use the above code and directly link it to my cells D6:26 I know its simple but no matter how I try and specify the range it doesnt work. Thank you! Lynda. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Probably and Easy one | Excel Discussion (Misc queries) | |||
Probably easy but I need help! | Excel Worksheet Functions | |||
new user with easy question? not easy for me | New Users to Excel | |||
easy one! | Excel Programming | |||
An easy one! | Excel Programming |