Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code Error
I'm having trouble with the following code, it gets stuck at
"sh.Range("Summary_Gross")." What I am trying to do is change the format of cells, which works fine, but instead of naming cells I would like to name ranges. Sheets("Contract Data").Select Range("C7").Select ActiveCell.FormulaR1C1 = "$" Range("G4:G34").NumberFormat = _ "[$$-409] #,##0.00;[Red]-([$$-409] #,##0.00)" Range("C13:C14").NumberFormat = _ "[$$-409] #,##0.00;[Red]-([$$-409] #,##0.00)" Range("C20").NumberFormat = _ "[$$-409] #,##0.00;[Red]-([$$-409] #,##0.00)" sh.Range("Summary_Gross").NumberFormat = _ "[$$-409] #,##0.00;[Red]-([$$-409] #,##0.00)" sh.Range("Summary_Rate").NumberFormat = _ "[$$-409] #,##0.00;[Red]-([$$-409] #,##0.00)" sh.Range("Summary_Prev").NumberFormat = _ "[$$-409] #,##0.00;[Red]-([$$-409] #,##0.00)" sh.Range("Adj_Gross").NumberFormat = _ "[$$-409] #,##0.00;[Red]-([$$-409] #,##0.00)" sh.Range("Adj_Rate").NumberFormat = _ "[$$-409] #,##0.00;[Red]-([$$-409] #,##0.00)" sh.Range("Adj_Prev").NumberFormat = _ "[$$-409] #,##0.00;[Red]-([$$-409] #,##0.00)" sh.Range("K108:K105").NumberFormat = _ "[$$-409] #,##0.00;[Red]-([$$-409] #,##0." sh.Range("I67").NumberFormat = _ "[$$-409] #,##0.00;[Red]-([$$-409] #,##0." sh.Range("D12:D13").NumberFormat = _ "[$$-409] #,##0.00;[Red]-([$$-409] #,##0." sh.Range("K16").NumberFormat = _ "[$$-409] #,##0.00;[Red]-([$$-409] #,##0." Suggestions? JIM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
OnTime code error "can't execute code in break mode" | Excel Programming | |||
Error in Excel VBA Code (Error 91) | Excel Programming | |||
How can I still go to the error-code after a On Error Goto? | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming |