how do i use data in a cell into a range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Heya

Ok here is the problem.
let say i have this

i wnat to make a cell that contain eg C25 into my macro

Range("C25").Select

but it recognize it as the cell..but what i want is the data...as a range
 
You are asking it to select the cell, so that is what it is doing. Wha
do you want to do with the cell and it's contents
 
Heya

Me bad

ok ...let assume that a cell C25 has a data in it that is d28

Now i want to use this cell into my macro

Range("C25").Select

but want the actual chosen rage to be d28

I have to locate a variable in an table,get its reference then move the
column offset by 1.
 
hi,
Not sure what you want but if you want the data in the
cell that would be
Range("C25").value
to get it's value into your macro the use the set command
Set range("C25") = myvariable
debug.print Myvariable.value
Regards
Frank
 
Back
Top