Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |