object error

I have tried to resolve this through threads and videos but can't get it to work. My understanding of set and objects are not there yet. I am getting the error "object variable or with variable not set when I click the combobox selection to put in cell. Here is my code and would appreciate any...

Hi Please could you help, I'm getting an "object required error" on this following code: Would appreciate any guidance. Thank you Sub PopulateColumns() Dim ws As Worksheet Dim inputmonth As String inputmonth = InputBox("Enter CRA Reporting Month") For Each ws In...

I have been working in document.docx where I want to open Excel file as object, find some text in this object and delete entire row of found text. I had opened the EMEA CC FINAL LIST.xls successfully but I am getting error in finding the text. I am new to VBA, please help. Dim xC As Object...

My input box fills the inboxfldr in this code Set Fldr = olNs.GetDefaultFolder(olFolderInbox).Folders(inboxfldr). If the object isn't found the vba gives a run time error. I want to suppress that error, prompt a message box that folder isn't found and just re-promt my inputbox. Looking for some...

Hi all, so I am trying to resize the selection to equal a number of rows and columns specified in cells C45 and C46, respectively. My code gives me a 1004 Object Orientated error. Does anyone know how to fix this? Sub TableExpand() Worksheets("Sheet1").Activate numrows =...

Hi All, I'm struggling with InputBox in Excel 2010. I think I've set type to 8, for input range. But, I get Object error 424, Object Required. So, I added the line Set ProductNames = Nothing, to confirm it's a Range object using Set. Same problem. I also tried custom error handling, e.g. On...