activecell.range

[TiaXL]

what is the syntax to determine the range reference of the activecell (for e.g "A1") to use in a formula

activecell.range or activecell.address ?

 

[VoG]

ActiveCell.Address

 

[Jonmo1]

How about just ActiveCell ?

ActiveCell.Value = "Hello"


ActiveCell - this by itself is a range OBJECT.
ActiveCell.Address - This is a STRING representing the address of the active cell

 

[TiaXL]

ActiveCell.Address

thanks if I want to then store this and use in a formula does this suffice ?

dim iMinRow as range
dim iMaxRow as range

iMinRow = activecell.address
iMaxRow = activecell.address

activecell.formula = "=SUM(" & iMinRow & ":" & iMaxRow & ")"

 

[TiaXL]

How about just ActiveCell ?

ActiveCell.Value = "Hello"


ActiveCell - this by itself is a range OBJECT.
ActiveCell.Address - This is a STRING representing the address of the active cell

I dont want the value I want the cell reference to use in a formula as I cant get my head round the worksheet.function at the moment :P

 

[Peter_SSs]

ActiveCell.Address is equivalent to ActiveCell.Address(1,1) which would return "$A$1"

If you just wanted "A1" then
ActiveCell.Address(0, 0)

Other combinations of 0s and 1s to get a mix of relative and absolute addresses.

 

[VoG]

That would be something like

ActiveCell.Formula = "=SUM(" & ActiveCell.Address & ")"