runtime 1004

Hello All, I am trying to populate cells with a date that is located next to a cell with the word "Visit." This is my code: lRow = Cells(Rows.Count, "A").End(xlUp).Row Do While True If Cells(lRow, 6) = "Visit" Then sLastValue = Cells(lRow, 5) Else Cells(lRow, 5) = sLastValue End If...

Hey, I have a Pivot table called "PivotTable1" in Excel and would like to change the filter on it using VBA. The field I would like to change is a date field called "LEASE SIGNED BY LANDLORD". I would like to select all of the dates and leave out the blanks (doing this manually requires checking...

Hey everyone! I'm currently working on a project where I need to create 5 tables (one for each business day) and populate them with data from another page in the same worksheet. Right now I'm doing this by simply adding rows to the tables that already exist and already have VLookups set up the...

I have a Macro Where i am trying to Have the Data In Sheet1 and Sheet2 into sheet3 This is my Macro. Sub moveitems() ' ' moveitems Macro ' This is To Put the Items in Sheet1 and sheet2 Into Sheet3 With Data. ' ' Range("B1,C1,D1,E1").Select Range("Table1[[#Headers],[18th]]").Activate...

Hi, Wondering if someone could help. I keep getting a runtime 1004 error when I run the following code, even though it has been ok up until now. Last time, I thought it maybe that the file was too big, so reduced the size of the file, but this time it doesnt seem to be working. Can anyone...

Hello All! Let me start by thanking everyone that posts here. I'm a VBA beginner and I've been able to learn so much by writing my code then making it work by looking through this forum. Thanks! Thank being said I've run into an issue that I haven't been able to find a resolution to so I...