ws.rangea

  1. B

    Puzzled by VBA formula

    Dim Column_L_L As Long Set ws = Sheets("Members") Column_L_L = ws.Range("A" & Rows.Count).End(xlUp).Row ws.Range("L2:L" & ws.Range("A" & Rows.Count).End(xlUp).Row).Formula = _ "=YEARFRAC(K2, TODAY(), 1)" ws.Calculate This bit of code creates an issue in my project. If...
  2. K

    Run Multiple Command Buttons in order

    I'm new to vba and need help with a vba script. I have two command buttons that were created within a UserForm1. I've tried to run the second by using "Call", but it does not work. Is there a way to run button 1 first, then button 2 immediately after 1? Public Sub CommandButton1_Click()...
  3. B

    Assign sequential number to the cell with condition

    Hi I have the following 2 columns. I want to assign the order no. for each client using VBA as below. There are several worksheets in the workbook. But the code doesn't work. Please help. <colgroup><col><col></colgroup><tbody> <colgroup><col><col></colgroup><tbody> Order Client 1 123 2...
  4. P

    Using Listbox selection to name worksheet

    Hi All I'm hoping this is simple. I have a userform that I want to copy data from to two worksheets. The first worksheet if fixes, the second worksheet is chosen from a userform list box selection. The listbox is populated with the names of the worksheets automatically so I know the sheet...
  5. B

    check if value exist in table, if not then....

    Hey I have a table in access called Log_Table Id like the user to press a button that checks if the value "KLAR" is in the column named "HRWEBB CHECK" How do i do this? Ive done it with Excel, but dont know how to make this code work in access (code from excel, how to make this work in...

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