Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cells content
Hi:
The following code does not obtain the active cells content, what's wrong ActiveCell.Value Any help apreciated. Sean. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cells content
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 "Sean Farrow" wrote: Hi: The following code does not obtain the active cells content, what's wrong ActiveCell.Value Any help apreciated. Sean. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
cells content
On Sun, 21 Dec 2008 21:11:48 -0000, "Sean Farrow"
wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA to select all cells with content | Excel Discussion (Misc queries) | |||
Formula Content linked to other cells formula Content | Excel Discussion (Misc queries) | |||
naming cells for their content | Excel Programming | |||
exchange content of cells | Excel Discussion (Misc queries) | |||
AutoCoplete cells content | Excel Programming |