Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA get range from cell offset
I have a macro that allows pictures to be added to a cell defined as a
range and, as such, takes the range as an input i.e. Sub InsertPicture(PictureFileName As String, TargetCell As Range, _ CenterH As Boolean, CenterV As Boolean) However, my main code is using cell offsets in all of the processing and I am unsure as to how to convert my offset cell to the TargetCell value required above i.e. Set fdcCell = FDCs.Cells(fdcrownumber, 1) -- the initial cell definition The cell I need to find the range value for is fdcCell.Offset(0, 18) I guess I have to create a range variable such as "Dim pictRange As Range" What is the command to set this pictRange value to that of the cell defined by offset fdcCell.Offset(0, 18) ?? Cannot get this right!! Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum variable range of column entries in offset cell | New Users to Excel | |||
Moving into a cell range using Offset and LBound | Excel Programming | |||
Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
Selecting a range offset from a cell | Excel Programming | |||
Selecting cell using range.offset | Excel Programming |