Hi Team,
Can someone help me by providing the VB relative refering code for selecting the Activecell + Cell adjacent to the activecell.
Due to the dynamic nature of the data, wouldn't be able to define the exact range and column of the cell. Because of which I am using the find command in order to identify the field and in addition to that I want to select the cell (0,1) next to the activecell.
Can someone please help me in doing the same.
Regards,
Raghu
Something like;
ActiveSheet.Range(ActiveCell, ActiveCell.Offset(0, 1)).Select
Hi, Raghukumarn,
if you use FIND you could set a range to the found and work with that range instead of ActiveCell via Activate.
Ciao,
Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hello,
You can try these alternatives one good and one better/ All do the same thing look for "New" and select the cell and the one next to it.
anotherPlease Login or Register to view this content.
the bestPlease Login or Register to view this content.
ThanksPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks