rangee2.select

Hello, I'm finding the last row with data in my range and then I'm attempting to use the cell number in a formula. ''' firstRow = sht.Cells(sht.Rows.Count, "D").End(xlDown).Row lastRow = sht.Cells(sht.Rows.Count, "D").End(xlUp).Row Range("E1").Select ActiveCell.FormulaR1C1 = "Late /...

Hello, I have a macro that is pulling data from a sheet Cycle_14a_Output.txt. There will be multiple sheets used for this project, all name Cycle_XXa_Output.txt. I've added an input box to ask what the number of the file should be. How can I add the Input Data into the formula string? <Code>...

Hello, This is a part of the code that i have written, and what i wanted to do is to add a wildcard at the lookup value like in a common formula for instance : =VLOOKUP("*"&C1&"*";A1:B2;2). I need to apply the asterists at the beginning and at the end in the code. Range("E2").Select For i =...

I have been trying to get my macro to auto fill a vlookup formula from cells E2 to the last row based on how many rows data is the spreadsheet "Data". This number will constantly change. Here is my coding: Dim Data As Worksheet Set Data = ThisWorkbook.Sheets("Data") Dim LastRowData As Long...