Ready to get started with anonymous questions today? It's easy! Learn more.
Dim ws As Worksheet: Set ws = Worksheets("MySheet") Dim CCC As Range Set CCC = Range(Cells(1, 1), Cells(1, 7)) ' Seems OK Set CCC = Range(ws.Cells(1, 1), ws.Cells(1, 7)) ' Computer gets angry
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.