Reference to variable Cell Image to Other sheet

[sureshtrb]

Recalling data in userform from excel saved data, data works and image (Saved in cell) also works if I refer

Set CopyImage1 = Worksheets("Data").Range("QW14")

I don't want to refer a particular cell the range should be variable like

Set CopyImage1 = Worksheets("Data").Range(Foundcell.offset(0,464))

Unable to achieve this.
Any help is appreciated.
Thanks

 

[sureshtrb]

Any Help Please?

 

[sureshtrb]

I hope my question is clear?

 

[Andrew Poulsom]

If you have already assigned a Range object to Foundcell:

Set CopyImage1 = Foundcell.Offset(0,464)

 

[sureshtrb]

Still No success.
"assigned a Range object to Foundcell:"

[/COLOR]Dim FoundCell As Range
Set FoundCell = Cells.Find(what:=Me.CBSearchResult.Value, _
                                                            After:=Cells(1), _
                                                            LookIn:=xlValues, _
                                                            lookat:=xlWhole, _
                                                            SearchOrder:=xlByRows, _
                                                            SearchDirection:=xlPrevious, _
                                                            MatchCase:=False)
[COLOR=#333333]

This is what you mean?

 

[Andrew Poulsom]

Yes, in what way is your code not working?

 

[sureshtrb]

Retrieving to the userform data and the saved pictures in the cells for editing
When i Refer the exact cell reference ex. "QW14" it copies to the temporary sheet and also retrieves to image control to the userform.
If i refer found.cell.offset(0,"xx" or 464), the temporary sheet is created but its blank and no image is copied.
I am struck with this .Range..
Hope it's clear and if you need further info, pl let me know.
Thamks

 

[Andrew Poulsom]

What does Foundcell.address return?

 

[sureshtrb]

returns to Column "A" entered data reference.
With reference to the matching search box value, the row will be selected and retrieved.

 

[Andrew Poulsom]

If Foundcell.Address returns A14 then Foundcell.Offset(0, 464).Address will return QW14. So I don't know why you are having a problem, sorry.