#16
|
|||
|
|||
Thanks i built this macro to change it before I copy paste.
Sub Range_Example_2() With Range("W2:AZ10") .Value = .Value End With End Sub |
#17
|
|||
|
|||
It's me again. Sorry to be such a pain. I have this code below and if there are no blank cells in Range ("J2:J") i get a message box and the rest of the macros don't run. I can't figure out how to make it go to Call Macro4 if there are no blanks in cells in Range ("J2:J").
Range("J2:J").Select Selection.SpecialCells(xlCellTypeBlanks).Select Selection = Range("X6") With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .Color = 65535 .TintAndShade = 0 .PatternTintAndShade = 0 End With Call Macro4 Call Macro5 Call Macro5 Call Macro6 Call Macro7 Call Macro8 Call Macro8 Call Macro9 Call Macro10 Call Macro10 Call Macro11 |
#18
|
||||
|
||||
The idea of a forum is not to post every single question you have as one long thread.
J2:J is not a valid reference. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using Right and Len formulas together | PDGood | Excel | 4 | 11-20-2015 06:50 AM |
formulas | MSA5455 | Excel | 3 | 12-19-2014 01:50 AM |
Help with IF or ELSE Formulas | tsaladyga | Excel | 4 | 07-23-2014 09:04 AM |
Need help with formulas please | paul_pearson | Excel | 0 | 03-20-2013 06:51 AM |
IF Formulas | mizzamzz | Excel | 1 | 07-08-2010 02:32 AM |