Posted to microsoft.public.excel.programming

Mike[_92_] Mike[_92_] is offline

external usenet poster

Posts: 8

Reference Worksheet Name variable in VBA formula

Having trouble using variable in SUMPRODUCT formula...any help/comments
appreciated. I don't know how to use quotation marks (double or
single) correctly.

Dim FPsh = ActiveSheet.Name 'assign whsht name as variable FPsh
Worksheets("2005").Select

Range("E6").Formula = "=SUMPRODUCT((" & FPsh & "!$E$1:$E$1000=$C6)*" &
"(" & FPsh & "!$B$1:$B$1000(--(""2004/12/31"")))*" & "((" & FPsh &
"!$B$1:$B$1000<(--(G$4))))*" & "(((" & FPsh & "!$J$1:$J$1000)" & ")"

Many thanks...Mike

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
making a portion of reference to a worksheet variable in a formula	Celia	Excel Discussion (Misc queries)	1	October 25th 09 08:27 AM
Variable column reference in formula	excel help acct[_2_]	Excel Discussion (Misc queries)	2	January 16th 08 12:31 AM
Vlookup with variable worksheet reference	trempnvt	Excel Worksheet Functions	6	May 23rd 06 06:47 PM
how to reference a worksheet with a variable vs a name	ibbm	Excel Programming	3	April 17th 06 07:53 PM
Making a file and worksheet reference into a variable....	Mr Mike	Excel Worksheet Functions	3	July 6th 05 08:52 PM

All times are GMT +1. The time now is 10:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us