with end with statements

  1. A

    Excel VBA to Copy paste using with statement to return message box

    I need some advice to rectify the code below. I have this code to copy paste lines to another sheet for data compilation purpose. And I'm running well using the with statement below, the problem is, when there's no data to paste, I do not know how to end the code with message box. I see the...
  2. DDRA Steampunk

    How would I combine button 1 and 2? Can I use a With?

    I know I can combine more than one function on a button (as I have on each of these buttons), but I had no luck trying to combine the 2 buttons into 1. Seems like I should be able to do it with a "With" but I can't seem to make it work. I think it must have something to do with where I place the...
  3. H

    Basic Variable Problem

    Hi Everyone, First off, a huge thanks to everyone helping out here - I love this community and have learned so much from reading other threads. :) I'm trying to do a very simple for loop that cycles through sheets and executes a long code within that sheet. However, for some reason, the for...
  4. S

    With / End With:- Changing property of the Variable to be in date Format or Number format

    Hi, Im currently using With / End With statements to apply formulas or link in data via a named range. What I want to be able to do is change the property of what I'm linking in to be in date format. For example I have the code Set FiscalYrPrd = Range("AG7:AH" & .Range("AA" &...

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