Hello Guys,
When i use the Application.inputbox(), i select a value on the excel sheet to get it stored in some variable. I want the selected cell to be the Activecell cell now. Is there a way to do it?
Thanks in Advance
Unbenannt1.jpg
Hello Guys,
When i use the Application.inputbox(), i select a value on the excel sheet to get it stored in some variable. I want the selected cell to be the Activecell cell now. Is there a way to do it?
Thanks in Advance
Unbenannt1.jpg
That method is meant for the activesheet. Were you wanting to allow selecting some range on some other sheet as well?
If you post your code, it might be easier to see what might go amiss.
I would use Select but feel free to change to suit.
Please Login or Register to view this content.
Perfect! Thanks a lott!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks