Know how to convert a range to a string?
I've got a range object that I want to convert to a string so I can use in the PivotTableWizard method:
Dim rng As Range
set rng = Sheets("sales").Range("A1").CurrentRegion
I want to convert rng into a string like this:
Any help you can provide will be greatly appreciated.