rangej1.value

  1. V

    Worksheet change event

    Hello all Is it possible to use this worksheet change event for the whole column instead of the cell please Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Target.Address(False, False) = "I1" Then Range("J1").Value = Range("J1").Value + 1 End Sub
  2. R

    Saving Both Sheeting in a workbook

    This is the Current Code I am running for my "Next Invoice", the only problem I am Having it only save one of the two work sheets I am using...Can you give a not so smart guy a little help and saving both "Invoice" worksheet and CustomerCopy" worksheet? Sub NextInvoice() Range("J1").Value =...
  3. V

    VBA Kill file

    Afternoon all. I have been struggling with this for a while now and I wonder if you can help. I have a userform which enters data to the database, it then creates a folder, renames it then PDF's all of the worksheets into the new folder. The folder and PDF's change file name based on the...

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