Is this Possible

[joer55]

I have some macros that create pivot tables and charts. Is it possible to have a user input define date ranges in the row area of the pivot via a pop up?


THx

Joe

 

[iliace]

Public Function getRange() As Excel.Range
  Dim rng As Excel.Range
  
  Set rng = Application.InputBox("Select the data range:", , , , , , , 8)
  
  If Not rng Is Nothing Then Set getRange = rng
End Function