Reference to variable Cell Image to Other sheet

sureshtrb

Board Regular
Joined
Mar 24, 2013
Messages
105
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
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
If you have already assigned a Range object to Foundcell:

Rich (BB code):
Set CopyImage1 = Foundcell.Offset(0,464)
 

sureshtrb

Board Regular
Joined
Mar 24, 2013
Messages
105
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?

 

sureshtrb

Board Regular
Joined
Mar 24, 2013
Messages
105
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
 

sureshtrb

Board Regular
Joined
Mar 24, 2013
Messages
105
returns to Column "A" entered data reference.
With reference to the matching search box value, the row will be selected and retrieved.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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.
 

Forum statistics

Threads
1,082,344
Messages
5,364,810
Members
400,814
Latest member
gangstar67

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top