Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Offset
Hello,
I am trying to write some code that will select row32 of the active cell. This always needs to be row 32 becuase I want to get the interior colour value of that cell and apply that to the active cell. Here is my code so far: ActiveCell.Offset(Right(ActiveCell.Address, 2) - Right(ActiveCell.Address, 2) + 32, 0).Select If I put this into a message box then it always returns 32 so I know that works but it doesnt seem to work with the offset rule. Does anyone know why this is? I also need to get the value of the interior colour. i havent looked this up yet but again if anyone can help with that it would be appreciated. Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Programming | |||
Find, Copy offset to offset on other sheet, Run-time 1004. | Excel Programming | |||
select offset (variable ,1) to offset(variable ,variable) | Excel Programming | |||
Problem with Range.Cells.Offset and Range.Cells( row + offset, column) | Excel Programming |