Hi Guys
I need a simple solution to jump from ActiceCell cell +200. E.g. ActiveCell is F19027, after running the macro, selected cell should be F19227
Thanks !!
Hi Guys
I need a simple solution to jump from ActiceCell cell +200. E.g. ActiveCell is F19027, after running the macro, selected cell should be F19227
Thanks !!
Try:
activecell.Offset(200,0).Select
Great ! Thank you ! How could I make the newly selected cell a new color, e.g. Interior.color = 10079487 ?
Try,
HTH,Please Login or Register to view this content.
Maud
Perfect ! Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks