worksheet range

  1. F

    Paste chart to the first sheet with specific name beginning with ....

    Hi, Is it possible to write a code line that pastes a picture from worksheet A to worksheet B, whose name starts with "Sheet.....". I have multiple sheets named "Sheet1", "Sheet2", "Sheet3" etc. and I only want to copy&paste one picture to the first sheet that comes up first. and I can't use...
    • filido
    • Thread
    • copypaste picture sheet vba worksheet range
    • Replies: 1
    • Forum: Excel Questions
  2. M

    Userform_Initialize() Dim Range prevents userform from opening on other worksheets

    I'm creating a userform (SOP421) that will serve as a "quiz builder"; i.e. the label captions and option button captions are pulled from specific cells in Sheet3("TRAINING") so that the questions and available answers can be modified from within the worksheet. Initially, I got the form working...
  3. J

    Using a Variable within Userform.List Attempt 2

    Ok so i've been working on this inbetween my day to day job and i still can't work it out! :confused: I'll try and keep it simple: I am trying to populate 3 different answer sets within a Userform Listbox or ComboBox. The answer set displayed is dependant on what is selected on the "Answers"...
  4. J

    I have to select a sheet to copy range to array

    The following fails: Private Sub GetHierarchy(htable As Variant) Dim ws As Worksheet Dim cmax As Integer Dim rmax As Integer ' Dim htable As Variant Set ws = Sheets("Hierarchy") cmax = LastColumn(ws) rmax = LastRow(ws) htable = ws.Range(Cells(1, 1), Cells(rmax...

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