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"