Fred Evans
Board Regular
- Joined
- Apr 22, 2015
- Messages
- 60
Hello Everyone
I wrote a macro which is supposed to change the fill color of a cell- but when I run the macro
i get the error "runtime error 1004 application defined or object defined error"
what is it trying to tell me and how do i get the thing to work??
This is the macro
thanks
fred from south africa
I wrote a macro which is supposed to change the fill color of a cell- but when I run the macro
i get the error "runtime error 1004 application defined or object defined error"
what is it trying to tell me and how do i get the thing to work??
This is the macro
Code:
Sub blueme()
'
' blueme Macro
' Makes blue fill in cell
'
' Keyboard Shortcut: Ctrl+b
'
ActiveCell.Offset(-2, -22).Range("A1").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorAccent5
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End Sub
thanks
fred from south africa
Last edited by a moderator: