Amending Date Range In a Formula From A Macro-UserForm

[amish_z]

Hi

So I will explain in more details, the following formula downloads data from Google Analytics for a certain period :

=Dump(GoogleAnalytics("ga:XXXXXXX","ga:adCost,ga:impressions,ga:adClicks,ga:CTR,ga:CPC,ga:goal7Completions","2015-02-03","2015-03-04","ga:campaign","","ga:medium==cpc;"",1,5000,FALSE,FALSE))

I want to create a button that can look up new date ranges I type in cells and enter them into the formula above, replacing the dates currently in it.

I will be entering the new date ranges in cells "A5" for start date and "A7" for end date.

I know it's quite a complex idea, but if any1 can help I'd be very grateful

 

[FormR]

How can I get VBA to not add ' to the cell I am using?

You are not using R1C1 style so change:

ActiveCell.FormulaR1C1

to:

ActiveCell.Formula

 

[amish_z]

This done it!

All done! Love it

Thanks for all your help