Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using relative references in macro
I want to move the contents of a cell (in an array) when I know its column
and relative row number. The requested cell (date & time format) is in Column D and its relative row # is in cell E5. I want to move the contents of this cell to cell B1. The following is a sample of the table: Col D 7/16/2009 23:23:57 7/17/2009 4:10:07 7/17/2009 5:40:25 7/17/2009 20:58:30 7/17/2009 23:22:49 7/18/2009 3:00:51 7/18/2009 5:58:52 I've tried various approaches to specify the relative cell's location so I can move its contents but with no success. Help. Thanks for your assistance. Jim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using relative references in macro
If I understand your question correctly, try this...
Range("B1").Value = Cells(Range("E5").Value, "D").Value -- Rick (MVP - Excel) "Cinco" wrote in message ... I want to move the contents of a cell (in an array) when I know its column and relative row number. The requested cell (date & time format) is in Column D and its relative row # is in cell E5. I want to move the contents of this cell to cell B1. The following is a sample of the table: Col D 7/16/2009 23:23:57 7/17/2009 4:10:07 7/17/2009 5:40:25 7/17/2009 20:58:30 7/17/2009 23:22:49 7/18/2009 3:00:51 7/18/2009 5:58:52 I've tried various approaches to specify the relative cell's location so I can move its contents but with no success. Help. Thanks for your assistance. Jim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using relative references in macro
Rick,
It does what I want except I am 1 row low re the contents that I want to move. How do I change your command to move the contents of my relative row # +1? Thanks again for your help. BTW, all my attempts were much more complicated than the simple one line solution that you provided, and none of mine worked. Jim "Rick Rothstein" wrote: If I understand your question correctly, try this... Range("B1").Value = Cells(Range("E5").Value, "D").Value -- Rick (MVP - Excel) "Cinco" wrote in message ... I want to move the contents of a cell (in an array) when I know its column and relative row number. The requested cell (date & time format) is in Column D and its relative row # is in cell E5. I want to move the contents of this cell to cell B1. The following is a sample of the table: Col D 7/16/2009 23:23:57 7/17/2009 4:10:07 7/17/2009 5:40:25 7/17/2009 20:58:30 7/17/2009 23:22:49 7/18/2009 3:00:51 7/18/2009 5:58:52 I've tried various approaches to specify the relative cell's location so I can move its contents but with no success. Help. Thanks for your assistance. Jim |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using relative references in macro
Do you mean you want to add one to whatever is in E5? Is so...
Range("B1").Value = Cells(Range("E5").Value + 1, "D").Value -- Rick (MVP - Excel) "Cinco" wrote in message ... Rick, It does what I want except I am 1 row low re the contents that I want to move. How do I change your command to move the contents of my relative row # +1? Thanks again for your help. BTW, all my attempts were much more complicated than the simple one line solution that you provided, and none of mine worked. Jim "Rick Rothstein" wrote: If I understand your question correctly, try this... Range("B1").Value = Cells(Range("E5").Value, "D").Value -- Rick (MVP - Excel) "Cinco" wrote in message ... I want to move the contents of a cell (in an array) when I know its column and relative row number. The requested cell (date & time format) is in Column D and its relative row # is in cell E5. I want to move the contents of this cell to cell B1. The following is a sample of the table: Col D 7/16/2009 23:23:57 7/17/2009 4:10:07 7/17/2009 5:40:25 7/17/2009 20:58:30 7/17/2009 23:22:49 7/18/2009 3:00:51 7/18/2009 5:58:52 I've tried various approaches to specify the relative cell's location so I can move its contents but with no success. Help. Thanks for your assistance. Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro using relative references | Excel Worksheet Functions | |||
Fixed and Relative Macro References | Excel Programming | |||
Relative references and macro programming | Excel Programming | |||
macro vba relative references | Excel Worksheet Functions | |||
Making a macro references relative | Excel Programming |