bopha99
09-25-2013, 12:27 PM
Hi all,
I am working on a VBA code that I would like to have run data to the end of rows in a column. The number of rows change with every different spreadsheet that I would like to run the vba code on. Here is my code:
ActiveCell.FormulaR1C1 = "ISM"
Range("H2").Select
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-1],'Custom Input Symbols_2013-09-18 103538.csv'!C1:C3,3,FALSE)"
Range("H2").Select
Selection.AutoFill Destination:=Range("H500").End(xlUp)
How do I get this code to run to the end of each worksheet? What do I add/change? Thanks in advance!
I am working on a VBA code that I would like to have run data to the end of rows in a column. The number of rows change with every different spreadsheet that I would like to run the vba code on. Here is my code:
ActiveCell.FormulaR1C1 = "ISM"
Range("H2").Select
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-1],'Custom Input Symbols_2013-09-18 103538.csv'!C1:C3,3,FALSE)"
Range("H2").Select
Selection.AutoFill Destination:=Range("H500").End(xlUp)
How do I get this code to run to the end of each worksheet? What do I add/change? Thanks in advance!