andrewb90
Well-known Member
- Joined
- Dec 16, 2009
- Messages
- 1,077
Hello all,
I was hoping that info from the macro recorder would help, but it didn't do so well.
Here's what I have:
The commented out lines are what I would like to use, instead of just changing the text value. But putting them in doesn't work. I have this funny feeling it's pretty simple, its just in a different order than I got from recording...
Thanks,
Andrew
I was hoping that info from the macro recorder would help, but it didn't do so well.
Here's what I have:
Code:
With Sheets("Scheduler") .Cells(I + 85, j + 2).Value = "hi"
'.Pattern = xlSolid
'.PatternColorIndex = xlAutomatic
'.ThemeColor = xlThemeColorDark1
'.TintAndShade = -0.349986266670736
'.PatternTintAndShade = 0
End With
The commented out lines are what I would like to use, instead of just changing the text value. But putting them in doesn't work. I have this funny feeling it's pretty simple, its just in a different order than I got from recording...
Thanks,
Andrew