myfilename

  1. J

    Create .csv file from a workbook sheet with new filename and timestamp

    Hi all, Im not great at VBA by any means but since moving to mac I cant seem to do anything i used to do with ease. I am simply trying to create a macro that copies a sheet in my active workbook to a new .csv file with that sheet name as the title and todays date and time in the newly...
  2. B

    Subscript out of range (for some users)

    What is the most likely cause for this bit of code to work for one user but not another? It throws a subscript out of range error at the highlighted line when users other than me run it. This issue has vexed me for over 2 weeks now so any assistance is greatly appreciated, in advance. I will...
  3. S

    Missing an if issue

    I messed up an if here and was hoping someone could check it for me Private Sub Save_As()'Creates the SaveAs "Current Voyage" on the Noon Sheet Dim Path1 As String Dim Path2 As String Dim Path3 As String Dim myfilename As String Dim fpathname As String Dim resp As...
  4. S

    Copying Ranges from One Worksheet to another

    I read on a website tutorial that a more efficient way of copying and pasting ranges was to use the following: ' This is faster Range("A1:A10").Value = Range("B1:B10").Value ' This is slower Range("B1:B1").Copy Destination:=Range("A1:A10") I was led to believe this way made the code run...
  5. V

    Create a folder structure with VBA

    Hello all This piece of code checks to see if a folder with the value "MyContact" exists and if not creates a folder on my S Drive with the folder with the value of "MyContact" It then saves the active sheet in this folder with the value from "MyFileName and "Mydate" sDir =...
  6. H

    Insert Formula in a cell

    Dim wb As Workbook Dim ws As Worksheet Dim TotalTrans As Integer Dim FoundRow As Range Dim MyFolder, MyFile, MyFileName, MySheetName, ReportDate As String Dim FileType As String Dim MisFileName() As String, PaymentFileType() As String Dim MisTrans() As Integer Dim i, j, k, m As Integer i = 2 j =...
  7. R

    VBA - Autofill a VLookup Formula (under a filter)

    Hi all, I'm currently trying to make a macro which autofills a Vlookup from another workbook. I managed to get most of the macro working, except that it would't autofill to the rest of the empty spaces in row BA no matter what I tried. It was to only be the empty cells under the filters setup...

Watch MrExcel Video

This Week's Hot Topics

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
Top