variable in range selection

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
variable in range selection

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

June 2nd, 2014, 12:41 PM

Snoozy

Registered User

Join Date: Jun 2014

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

variable in range selection

Code:

'Creating Pivot cache
Set pc = ActiveWorkbook.PivotCaches.Create(xlDatabase, "Sheet1!R8C6:R8C7")

Hi
I want to use a vaiable named chk_raw at the place of R8 . How can i do that?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If not last cell in selection range.	Wenggo	Excel VBA	6	December 11th, 2013 01:12 PM
Search & Replace Text in Selection/Range	ArchieDog	Word VBA	3	May 5th, 2009 02:21 AM
How to get nodes from Selection/Range	kaps77	Javascript How-To	1	June 17th, 2007 07:38 AM
Defining a Dynamic Range using a variable	Alseikhan	Excel VBA	0	March 27th, 2006 02:26 AM
Range selection	keithd	Excel VBA	7	April 7th, 2005 11:29 AM