rangen4.value

  1. I

    only one code executes after i merged two codes together

    Morning, I have merged two codes together but the seocnd part of the code does not execute / run I press my PRINT 1 INVOICE BUTTON on my worksheet. The invoice is then printed. I see the msgbox CLEAR INVOICE AFTER PRINTING. I press the OK button but after the msgbox is closed then this is...
  2. I

    Run Time Error 13 Type Mismatch

    Evening, After i print my invoice i then use a button to clear the cells on my worksheet.. This is the code that is used on the button. Private Sub Clear_Invoice_After_Printing_Click() Dim strFileName As String strFileName = "C:\Users\Ian\Desktop\REMOTES ETC\DR COPY INVOICES\" &...
  3. I

    Existing code needs an edit

    Morning all, I have a code which works well & saves as a Word doc I would like some advice on having save as a pdf please. I have recorded a macro of saving a pdf but unsure what i need to remove from the existing code to apply the pdf save option. Both codes supplied below if you could...
  4. I

    Alert message for duplication of a file

    Morning, I have the following supplied code which i run after i have printed an invoice. It saves a word invoice to the folder mentioned & informs me with a message box once done. Could you advise a edit where it will only allow the save to go ahead if that invoice number does not exist. I mean...
  5. I

    One code updates two worksheets

    Morning, I have the following supplied code which works fine. The worksheet that this code is on is named INVOICE. I have copied this worksheet & named it INVOICE 2 What i would like to do is after the current invoice number has incremented by 1 on INVOICE 1 have the same happen for INVOICE 2...

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