how to acheive this functionality

jkpd2000 · May 21st, 2002, 08:16 AM

i want to put the range in a variable and use it in range method.

i tried this , it is not working

t = "d6:d7"
Range(t).Select

kkknie · May 21st, 2002, 08:20 AM

Works for me...

What error are you getting?

K

Ivan F Moala · May 21st, 2002, 08:23 AM

Quote:

On 2002-05-21 07:16, jkpd2000 wrote:
i want to put the range in a variable and use it in range method.

i tried this , it is not working

t = "d6:d7"
Range(t).Select

T should be dim as a String variable.
Worked for me ??

jkpd2000 · May 21st, 2002, 08:23 AM

object doesn't this property or method

jkpd2000 · May 21st, 2002, 08:28 AM

i got it , i didnt put Dim statement...

Is there a function to get cell name

kkknie · May 21st, 2002, 08:34 AM

Mine worked without a dim statement. Not sure why it is necessary. I even dimensioned t as a variant and it worked.

Anyway, you got it working, so does it really matter...?

As for a cell name, if you mean address, you can use ActiveCell.Address and will get something like $A$1. Or ActiveCell.Row and ActiveCell.Column will give you 1 and 1. Or activecell.name will give =Sheet1!$A$1.

K

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 08:16 AM	#1
jkpd2000 Board Regular Join Date: May 2002 Posts: 91	i want to put the range in a variable and use it in range method. i tried this , it is not working t = "d6:d7" Range(t).Select

May 21st, 2002, 08:20 AM	#2
kkknie Board Regular Join Date: Apr 2002 Location: Greenwood, SC Posts: 677	Works for me... What error are you getting? K

May 21st, 2002, 08:23 AM	#4
jkpd2000 Board Regular Join Date: May 2002 Posts: 91	object doesn't this property or method

May 21st, 2002, 08:28 AM	#5
jkpd2000 Board Regular Join Date: May 2002 Posts: 91	i got it , i didnt put Dim statement... Is there a function to get cell name

May 21st, 2002, 08:34 AM	#6
kkknie Board Regular Join Date: Apr 2002 Location: Greenwood, SC Posts: 677	Mine worked without a dim statement. Not sure why it is necessary. I even dimensioned t as a variant and it worked. Anyway, you got it working, so does it really matter...? As for a cell name, if you mean address, you can use ActiveCell.Address and will get something like $A$1. Or ActiveCell.Row and ActiveCell.Column will give you 1 and 1. Or activecell.name will give =Sheet1!$A$1. K