LinkBack URL
About LinkBacks
Hello,
There are two ways to select Range "B1" in VBA:
Cells(1,2) or Range ("B1")
I want to select a range "A1:B10". I can write:
Range ("A1:B10").Select
But how can I write this range using "cells"
Cells([1,2:1,10)?
Hello,
There are two ways to select Range "B1" in VBA:
Cells(1,2) or Range ("B1")
I want to select a range "A1:B10". I can write:
Range ("A1:B10").Select
But how can I write this range using "cells"
Cells([1,2:1,10)?
Please Login or Register to view this content.Please Login or Register to view this content.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
For A1:B10 it'd be
Please Login or Register to view this content.
Also a 3rd wayPlease Login or Register to view this content.
Last edited by ByteMarks; 09-24-2024 at 07:39 AM.
Thank you. Works perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks