specific cell start macro question

[moncode]

I need to create a macro that excel will ask me a question ''In witch cell do you want to start ?'' let's say I choose B10 than when I press enter then what ever the rest of the macro is it will start in B10.

Thank you

 

[tygrrboi]

what is in the rest of the macro?

 

[Momentman]

Welcome to the forum

You can use an InputBox

Dim rng As Range
Set rng = Application.InputBox(Prompt:="Select the starting cell", Type:=8)

 

[moncode]

Thank you from Canada, working