Input box: can't figure out how to activate that selection for hte rest of the macro

Hello all,

I've built a macro that takes action off pivot tables, but since the tables/layout change every time the source data is updated, I can't rely on the cells to be the same. Therefore, I thought about a user input box, but I can't seem to get the rest of the macro to run. I thought I needed a select command, but I just can't figure it out with google... Coming to the pros... I know this is a pretty basic problem, so any help is appreciated.


Dim Rng1 As Range
Set Rng1 = Application.InputBox("select cell", Type:=8)
Selection.ShowDetail = True
Sheets("Sheet1").Select
Sheets("Sheet1").Name = "PendingInitial"

I must be missing something. To me it seems you are just asking how to select the cell that the user inputs in the inputbox:

Please Login or Register  to view this content.

I must be missing something.

Yeah, it really was that simple... Learing VBA through trial and error. Thank you very much for the info!