I have absolutely NO experience in programming Macros (but I can still record Macros, and that is what helps me)
So, I'm asking how to 'slot' this part of a macro, into a whole macro code? Here they are, the whole macro:
Sub CaseOpen1() ' ' CaseOpen1 Macro ' ' With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .ThemeColor = xlThemeColorDark1 .TintAndShade = 0 .PatternTintAndShade = 0 End With End Sub
And, the part of the macro I want to 'slot in':
CaseOpen1 Macro Dim rng As Range Set rng = ActiveSheet.Range("G5") ' ' ' 'With rng.Interior '
Oh, and if you think there is an error in one of the codes, you can feel free to correct. You're bound to do better than me.
All help appreciated. :)