Posted to microsoft.public.excel.programming

Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline

external usenet poster

Posts: 1,045

Problems with setting .Values with vba

On Thu, 17 May 2012 23:10:36 +0000, confusedXLuser wrote:

Can anyone tell me why what appears to be the same string apparently
isn't?

Your second string is missing a right parenthesis:

RangeStr = "=('2012'!R10C2:R10C27,'2012'!R34C2:R34C28)"
-- =('2012'!R10C2:R10C27,'2012'!R34C2:R34C28)

RangeStr = "=('" & MyYear & "'!R10C2:R10C27,'" & MyYear & "'!R34C2:R34C28"
-- =('2012'!R10C2:R10C27,'2012'!R34C2:R34C28

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
Problems with setting up a billing budjet	JoeStL	Excel Worksheet Functions	1	November 25th 05 09:16 AM
Problems Setting properties of class module	Andibevan[_4_]	Excel Programming	2	October 2nd 05 01:44 PM
Problems setting Application.DefaultFilePath	paulojfonseca	Excel Programming	1	July 6th 05 11:24 PM
Setting up autorecovery problems	Jeff	Excel Programming	1	February 2nd 05 08:29 PM
Problems with setting values in a listbox	kankal	Excel Programming	1	November 26th 04 09:12 AM

All times are GMT +1. The time now is 11:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us