Posted to microsoft.public.excel.programming

external usenet poster

Posts: 9

using variable in setting and ActiveCell

I would like to replace the 'a1' with a String variable I have defined
earlier in the script in the following line:

ActiveCell.FormulaR1C1"=SUMIF('1a'!R6C1:R[32]C1,R5C1:R[32]C1,'1a'!R6C10:R[32]C10)"

I am trying to automate the creation of summary lines on a sheet for a
range of sheets in my workbook.

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
If activecell.column = variable then activecell,offset (0,1)	Battykoda via OfficeKB.com	Excel Discussion (Misc queries)	1	October 2nd 07 08:05 PM
Setting ActiveCell color	Peter Wells[_2_]	Excel Programming	3	November 24th 06 07:39 PM
Copy content of ActiveCell in a variable	Ulrik loves horses	Excel Programming	2	October 8th 06 11:05 PM
setting range from activecell in macro	Giz	Excel Programming	1	March 11th 05 05:16 PM
setting a range variable equal to the value of a string variable	Pilgrim	Excel Programming	2	July 1st 04 11:32 PM

All times are GMT +1. The time now is 05:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us