simple code problem

  1. B

    Reduce the quantity of calculations

    I have a very large excel. I have countifs that verify if something is in two categories but, there is a lot of blank cells. I was thinking about adding sthg like : =if( cells blank ; 0 or null or something ; countifs( )) Would it be possible, and more important, would it reduce the quantity...
  2. An Quala

    Multiple Times Paste within the same sheet

    Hello, It's a pretty straightforward issue, I need to paste a set of rows (template), available in the first 3 columns of the excel sheet multiple times, for instance, 500 times, can anyone please help me to that with a VBA Code? I am a very beginner with VBA. Thank you. C4
    • An Quala
    • Thread
    • copy & past rows vba copy & paste simple code problem simple fix - i think? vba
    • Replies: 10
    • Forum: Excel Questions
  3. M

    Mega Quick VBA Amendement

    Afternoon all, Really quick one. I have some code (below) that generally works fine (to filter sheets), however, I don't want it to run on a new sheet called 'Summary' and I am getting a debug error. Can someone add a line to basically say 'ignore Summary sheet' and run only on "Sheet 1"...
  4. M

    Simple VBA Amendment

    Hello all, A really simple one for you folk I'm sure. I've got some existing code which I need to adapt ever so slightly. 1) The code currently runs on all sheets except 'Summary', but I need it to run on all sheets except 'Summary' and 'FAQs' 2) The other tabs have an autofilter on row 4...
  5. A

    Cut and paste problem. I'm a newbie

    Hello everyone! I am trying to create a button which cuts cells Bx to Fx if the cell Fx contains the word "outlier" and paste it to a different part of excel sheet. My code seems to work up to the "Cut" part but stops at the paste. It has an error on "ActiveSheet.Paste" part of the code. Please...
  6. C

    If, Then Statement based on Data Validation

    Hello, I am trying to use an If then Statement so that if certain text is selected in a data validation dropdown a certain value or formula is output. The output I use is just as an example. I have just not been able to get it to read the If statement. Sub Sheet2() If Range("B11").Value =...
  7. N

    Clearing the data from mutiple workbooks using VBA

    Hello, I am brand new to VBA and I have some code to transfer data from multiple spreadsheets into one master spread sheet. This works ok but at the end I need to clear the days data from each of the spreadsheets so the data can be transferred again the next day with out duplicating. Is there...

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