Glasgowsmile
Active Member
- Joined
- Apr 14, 2018
- Messages
- 280
- Office Version
- 365
- Platform
- Windows
I've got this range I'm trying to work with and do the following but I'm getting an error message for application or object-defined error. When I use the full range it seems to be the AB sections that are causing the problem. When I delete everything and just use the AB Range it works fine.
Should I even be listing it this way or is Dim as Range as better method?
Range
Code for the Range
Should I even be listing it this way or is Dim as Range as better method?
Range
VBA Code:
G9:G10, G12, G14, G16, G18, G20, J9:J10, J12, J14, J16, J18, J20, M9:M10, M12, M14, M16, M18, M20, P9:P10, P12, P14, P16, P18, P20, S9:S10, S12, S14, S16, S18, S20, V9:V10, V12, V14, V16, V18, V20, Y9:Y10, Y12, Y14, Y16, Y18, Y20, AB9:AB10, AB12, AB14, AB16, AB18, AB20
Code for the Range
VBA Code:
Sheets(3).Range("").Font.Color = vbBlack