Reference to variable Cell Image to Other sheet

sureshtrb

Board Regular
Joined
Mar 24, 2013
Messages
106
Recalling data in userform from excel saved data, data works and image (Saved in cell) also works if I refer
Code:
Set CopyImage1 = Worksheets("Data").Range("QW14")
I don't want to refer a particular cell the range should be variable like
Code:
Set CopyImage1 = Worksheets("Data").Range(Foundcell.offset(0,464))
Unable to achieve this.
Any help is appreciated.
Thanks
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
If you have already assigned a Range object to Foundcell:

Rich (BB code):
Set CopyImage1 = Foundcell.Offset(0,464)
 
Upvote 0
Still No success.
"assigned a Range object to Foundcell:"
Code:
[/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?

 
Upvote 0
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
 
Upvote 0
returns to Column "A" entered data reference.
With reference to the matching search box value, the row will be selected and retrieved.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,560
Messages
6,114,309
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top