Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.scripting.vbscript
|
|||
|
|||
Converting a range to string
Hi,
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: "sales!R1C1:R796C6" Any help you can provide will be greatly appreciated. Robert Stober |
#2
Posted to microsoft.public.excel.programming,microsoft.public.scripting.vbscript
|
|||
|
|||
Converting a range to string
One way:
str = rng.Parent.Name & "!" & rng.Address(True, True, False, False) In article , "Robert Stober" wrote: Hi, 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: "sales!R1C1:R796C6" Any help you can provide will be greatly appreciated. Robert Stober |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting A String to a Column of Data | Excel Worksheet Functions | |||
Converting string to number | New Users to Excel | |||
Converting a range of Excel 2003 Cells to a Single text string | Excel Discussion (Misc queries) | |||
Converting datetime from character string | Excel Worksheet Functions | |||
Converting string of letters to Number | Excel Discussion (Misc queries) |