vba range across sheets

  1. S

    Need to help to save data from Excel to XML

    Hello Everyone, Need help to save excel sheet data in xml format. For example, i need to save the data from Sheet1 of my workbook in xml format seperate file. From the following range, i can only copy "Column A" data but i need to expand the range of the column. Range("A1:A" &...
  2. M

    Copy Range Based on Sheet Name VBA

    i'm New VBA and Marcos and am hoping someone can help. I have workbook with 50 plus sheets and I am trying to create a Macro that will copy the same range of cells on all sheets that have "Box" in the in the name and copy it to a Master Sheet in the same workbook with the originating sheet...
  3. H

    Excel VBA Range

    my code is in a below line(runs perfect): Set rngItems = Sheets("Sheet1").Range("Name_List") Problem is, I don't want to go into VBA and change every time, rather I want to do it from Excel window only. I wrote this code but it is giving me error. sheet_loc is a single cell range in excel...
  4. S

    VBA compare range on multiple sheets

    MasterSheet1 Range B:B has unique values like ID1, ID2, ID10000, etc. There are 20 more sheets, named consecutively sheet2, sheet3,.. , sheet21. Each sheet represents a unique exclusive filter criteria, like sheet2 are all ID´s of items that are color "blue" and/or sheet3 has all the ID of...

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