cells content
Hi:
The following code does not obtain the active cells content, what's wrong ActiveCell.Value Any help apreciated. Sean. |
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. |
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 |
All times are GMT +1. The time now is 08:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com