cells content

[Sean Farrow]

Hi:
The following code does not obtain the active cells content, what's wrong
ActiveCell.Value
Any help apreciated.
Sean.

 

[FSt1]

hi
nothing is wrong. you're not using it right.
assign the activecell value to a variable.....
dim r as range
set r = activecell.value
msgbox r

or
move the value.........
range("A3").select
range("R4").value = activecell.value 'A3 would be the activecell.

if this doesn't help, perhaps you could explain more about what you are
trying to do.

Regards
FSt1

 

[Ron Rosenfeld]

Hi:
The following code does not obtain the active cells content, what's wrong
ActiveCell.Value
Any help apreciated.
Sean.

You are undoubtedly using it incorrectly, but just posting that line out of
context doesn't enable any specific advice.

It would also help if you indicated what happens when that line is activated,
and also the address and contents of the active cell.

Here is an example that might help:

===============
Sub foo()
Range("a1").Activate
MsgBox (ActiveCell.Value)
End Sub
==================

This will display in a message box the .value property of cell A1 on the active
sheet.
--ron