Malvaro

Junior Member

Posts: 11

Thanks for all your help!!! :)

Quote:

Originally Posted by Dave Peterson

a)

Range("B8:b" & rowcount).formula = "The details of my formula"

b)

Range("A7:BB" & rowcount).Select
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:= _
"'Raw Data'!R7C1:R" & rowcount & "C54").CreatePivotTable
TableDestination:="", TableName _
:="PivotTable1", DefaultVersion:=xlPivotTableVersion10

--

Dave Peterson

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding new variable	Raj	Excel Discussion (Misc queries)	1	May 5th 08 09:36 PM
VBA - variable declaration	Jeff	Excel Discussion (Misc queries)	3	January 9th 08 12:45 PM
Adding variable number of blanks	ringnab	Excel Discussion (Misc queries)	2	July 12th 06 09:29 PM
Adding 3 variable formula to a cell	kssflmail	Excel Worksheet Functions	3	February 20th 06 05:11 PM
adding variable number of columns	confused	Excel Worksheet Functions	5	September 23rd 05 10:09 AM

All times are GMT +1. The time now is 02:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us