Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Exctracting Literal Value From A String Variable


For arguments sake, I have a string variable such as,

R1 = \"RANGE(CELLS(ROWPOINTER, COLUMNPOINTER))\"

And, I want to use the literal value of r1 (minus the quotations) in
the Range function

RANGE(R1)

How do I go about accomplishing this task?


--
rocketslinger
------------------------------------------------------------------------
rocketslinger's Profile: http://www.excelforum.com/member.php...fo&userid=4093
View this thread: http://www.excelforum.com/showthread...hreadid=519955

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Use CountIf for a literal string chadkwelch Excel Worksheet Functions 3 March 21st 10 03:45 AM
Exctracting Data Brad Excel Worksheet Functions 1 January 20th 05 06:57 PM
setting a range variable equal to the value of a string variable Pilgrim Excel Programming 2 July 1st 04 11:32 PM
How do I convert an integer variable to a string variable? dumbass Excel Programming 2 May 21st 04 07:34 PM
User Defined Type Structure - want it to be variable not numeric literal WyoCracker Excel Programming 1 July 21st 03 09:28 PM


All times are GMT +1. The time now is 05:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"