object variable error

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...

Hi guys. I can't make this error to go away. Basically it is part of a loop where first we find a separate table in the bottom of a crystal style report, then we look in the shortened range (ErrorMachinerng) I get an Object Variable or With block variable not set error on the NumberOfStops =...

Hello. I am relatively new tocoding and have a problem. I have created a script that pulls data from multiple sheets into one sheet and adds the name of the original file (“Widget#”). I’m trying to copy and fill the empty cells with the file name as I will be creating a pivot table. I added...

HI There, I am trying the below code to use a dynamic range for lastfillrange in a combobox. It gives an error of Object variable not set dont know what happened!! Can anyone help? Private Sub ComboBox1_Change() Dim lastrow As Long Dim dyrange As Range lastrow =...