sheetshonda

  1. I

    Can you see an issue with this code please

    Hi, I have a code which works well & correct,it then calls the macro below. Sub sheettolist()' ' sheettolist Macro Sheets("HONDA SHEET").Range("A21:G21").Interior.ColorIndex = 6 Sheets("HONDA SHEET").Range("A21:G21").Copy Sheets("HONDA LIST").Range("A4").Insert Shift:=xlDown...
  2. I

    Suggestion for macro undo

    Evening, I have a code which has a call to macro function at the end of it, the macro is shown below. Basically the cells C2:D27 show an un-ordered placement but then the macro once runs places it from most popular to least popular sold items. Now this works very good BUT i overlooked that the...
  3. I

    All cells in code specified alter cell color apart from one

    Afternoon all, I am using the code shown below to copy the data from HONDA SHEET A17:G17 to HONDA LIST A4:G4 This happens after i make my selection from a drop list down in cell F17 Sub sheettolist()' ' sheettolist Macro Sheets("HONDA SHEET").Range("A17:G17").Copy Sheets("HONDA...

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