Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return to cell whose address is stored in different cell
Hi.. Thanks for your help! I am writing a macro in Visual Basic. I need to Select a Range from first Cell within the Range, copy the Range, paste the Range to a location with formulas so I can edit it, then copy the edited version of the Range and paste it back to it's orgional location (probably by using the first Cell selected). I've tried previous property, source range and afew other things that I couldn't make work. Got any Ideas???? -- spydor ------------------------------------------------------------------------ spydor's Profile: http://www.excelforum.com/member.php...o&userid=28438 View this thread: http://www.excelforum.com/showthread...hreadid=496963 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return to cell whose address is stored in different cell
Could you define a name for cell and then return to that name?
"spydor" wrote in message ... Hi.. Thanks for your help! I am writing a macro in Visual Basic. I need to Select a Range from first Cell within the Range, copy the Range, paste the Range to a location with formulas so I can edit it, then copy the edited version of the Range and paste it back to it's orgional location (probably by using the first Cell selected). I've tried previous property, source range and afew other things that I couldn't make work. Got any Ideas???? -- spydor ------------------------------------------------------------------------ spydor's Profile: http://www.excelforum.com/member.php...o&userid=28438 View this thread: http://www.excelforum.com/showthread...hreadid=496963 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can the column index in a cell address be made variable? | Excel Discussion (Misc queries) | |||
How do I return the cell address of the largest of a set of values | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions | |||
if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
Syntax for inferred cell references | Excel Worksheet Functions |