object variable not set

Hi all, I'm having problems with a simple piece of code which suddenly stopped working, and I don't recall changing anything which has caused this to break. The code says 'object variable or with block variable not set', but I have set the dim above. Here is my code: Dim ThisWorkBook As...

Hi: I'm trying to use this standard bit of code: Dim fd As Office.FileDialog Dim strFile As String Set fd = Application.FileDialog(msoFileDialogFilePicker) With fd .AllowMultiSelect = False If .Show = -1 Then strFile = .SelectedItems(1) End If End With But I'm getting...

I've cut down the code to show the specific line I'm having an issue with. Can someone help me understand why this variable won't set? Other variables (not shown in this snip) with slightly diffferent order in the Cells syntax get their values just fine. For example, when I use the vLocCell...

I get the following error "Object variable or With block variable not set" when I run the below code on a MAC however on a windows PC it works fine Option Explicit Sub create_and_email_pdf() Dim EmailSubject As String, EmailSignature As String Dim CurrentMonth As String, DestFolder As...

Good day all, I have reached the end of my own limited knowledge and ask if anyone here could help me? I have a simple spreadsheet, column(5) "E", has a pulldown with values P1 thru P4. The following code simply places an 'X' in column "A" when P1 is selected, and removes the 'X' when any...

I'm trying to assign a Class Module known as Port to part of another Class Module , here's the code so far: The port class module is as follows Private pName As String ' Properties Public Property Let Name(Value As String) pName = Value End Property Public Property Get Name() As String...

Can someone help me fix my code. I am trying to loop through a column that has numbers beside each of the new files. For each i it should set the range as an offset 2 columns over and pull that file name, but when it loops through I get a runtime error '91' Then at the bottom I am trying to...