end of statement

  1. L

    Compile Error with COUNTIFs

    <tbody> 0 down vote favorite I was wondering if you could figure out what was wrong with the following command...
  2. J

    VLOOKUP Expeected: end of statement Error

    Hello all. So I am trying to run a vlookup from yesterdays file, however as I want the file name to be easily changed, I have assigned it to a variable, rather than having to change 10 lines of code every time you want to change the name. The problem I am running into is getting an excepted end...
  3. J

    Compile error: expected end of statement

    I am in need of a way to consolidate data from multiple files into one file. I am using the code below to perform this task. There are 2 errors and I am at a loss for how to correct them. Any help would be greatly appreciated. Sub GetData()Dim strWhereToCopy As String, strStartCellColName As...
  4. C

    End of statement Error on If Statement in Macro

    Hi all I am trying to create an if statement within a copy paste pertaining to a rwo of data, when I add in the "SA" at the end the VBA editor comes up with a "Compile Error: Expected : End of statement: does anyone know how I could get around this? Code: 'creating document types FinalRow =...

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