lastrow.formula

Hello, I have the code shown below which runs properly and fills in columns with a "0" if the search work (in cell I1) is not present in cell B2. I would like for the cells to display " - " instead of "0" but I get "Run-time error '13' Type Mismatch". Can anyone explain why or how to accomplish...

HI All I am new to VBA and looking online and recording Macros to help build my code. But I am having a issue when I get to part of my code it is slow up and also making excel go into not responding. Is there anything I can do to my code to speed this up when I run it and also stop it going...

hi I have the code below where I have added a vlookup, but once the cells are updated I want to remove the vlookup, I have tried '.value=.value' but that didn't work can you help please? Private Sub CommandButton1_Click() Dim copySheet As Worksheet Dim pasteSheet As Worksheet Set copySheet...

Is there an easier way to fill column B with the month of the date in column A. This is what i am currently doing: Sheet1.Range("B3:B" & Lastrow).Formula = "=Text(A3,""MMMM"")"

So, I've been working on this for quite a while with no luck. All it's supposed to do is merge two files together. It works until I add a new parameter (location). I've tried several variations on the code with no luck. Do I have to add another VLOOKUP? 'Opening Source Files...

Hello All I have a userform with a combo box that is populated by a named range which returns a selected fiscal period (example: MAY-18). A user will select the period that corresponds with the file name they wish to open with the macro in order to pull cost data. Unfortunately I am getting...

Can someone show me how I can incorporate a 'LastRow' variable into a Formula? What I have here isn't working; Lastrow = Range("K55").End(xlUp).Row + 1 Range("L" & Lastrow).Formula = "=VLOOKUP(K "& Lastrow",$D$8:$I$31,6,FALSE)"

Hey there! I am trying to get some code to work and had a friend help me try to clean it up. It worked when he ran through it, but now I am getting a Compile Error. I have made the line where the error occurs bold. The string of code is as follows: I would also like to add that I renamed...

I have the following code to insert columns, but for some reason it won't insert them. It doesn't give an error, the macro just stops and doesn't insert: Sub Worksheet_S10() 'Activate Workbook Workbooks("WorkBook.xlsm").Activate 'Activate Worksheet...