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...
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...
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...
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
I was led to believe this way made the code run...
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"
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
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...