referencing worksheet

  1. S

    Referencing another Worksheet in VBA

    I was given this project to develop a form that by a click a button will send the answers to a separate table. It currently works. The user fills out the form in "Change Order Form (sheet1)" , when finished the submit button is clicked which then sends the responses a table in "Change Order Log...
    • scavazo4
    • Thread
    • 1.select activecell.offset0 activecell.value referencing worksheet vba
    • Replies: 10
    • Forum: Excel Questions
  2. M

    Getting Data From Last Years Accounts Workbook

    Hello all, I have had some great tips etc. from you Excel Experts and am hoping for more. You recently solved my 'INDIRECT' question which works well but now I am looking to copy 'cars in stock' data from a sheet in last years workbook into a stock book sheet in this years workbook. I would...
    • Matt53
    • Thread
    • copy indirect function protected sheet referencing worksheet sheet
    • Replies: 1
    • Forum: Excel Questions
  3. C

    Count on another worksheet not working

    Hi, So I have the below code which should read each row on the active worksheet and depending on the value of column H copy to the relevant worksheet in the workbook. Although when I run, y = ThisWorkbook.Sheets(area).UsedRange.Rows.Count + 1 does not update. Value is always 1 Dim area As...

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