Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by safetyrs
-
set cell range coordinates to variables
Getting Runtime error 1004: Application-defined or object-defined error. Roel, I used your line of code and it worked perfectly. Thanks a bunch. I've been banging my head over this because it appears that it should have worked but just wouldn't. Doing this will save me a lot of time as opposed...- safetyrs
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
set cell range coordinates to variables
Why doesn't the red line work? I'm trying to set cell range coordinates to variables for easier maintenance in the future in case rows/columns shift using VBA in Excel. This way I can change the variable values in one place instead of scattered throughout the code. There is a lot more to all of...- safetyrs
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
