| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro Help
Hello I am trying to figure out the command on how to pull up the cell rang value Example: Say "ActiveCell" is currently on "A1" how do i make 'y = A1' but by using ActiveCell i.e.: y = ActiveCell.Valu -- hemant ----------------------------------------------------------------------- hemants's Profile: http://www.excelforum.com/member.php...fo&userid=1503 View this thread: http://www.excelforum.com/showthread.php?threadid=26645 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Macro Help
how about activecell.address
or activecell.column or activecell.row -- Don Guillett SalesAid Software "hemants" wrote in message ... Hello I am trying to figure out the command on how to pull up the cell range value Example: Say "ActiveCell" is currently on "A1" how do i make 'y = A1' but by using ActiveCell i.e.: y = ActiveCell.Value -- hemants ------------------------------------------------------------------------ hemants's Profile: http://www.excelforum.com/member.php...o&userid=15031 View this thread: http://www.excelforum.com/showthread...hreadid=266457 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Macro Help
y = ActiveCell.Value
will place the value of the active cell in y y = ActiveCell.Address will place the address of the active cell in y -- Regards, Tom Ogilvy "hemants" wrote in message ... Hello I am trying to figure out the command on how to pull up the cell range value Example: Say "ActiveCell" is currently on "A1" how do i make 'y = A1' but by using ActiveCell i.e.: y = ActiveCell.Value -- hemants ------------------------------------------------------------------------ hemants's Profile: http://www.excelforum.com/member.php...o&userid=15031 View this thread: http://www.excelforum.com/showthread...hreadid=266457 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Hybrid Mode
