| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Row As Range
I am not sure what I have wrong here, I am not sure if it is just a simple formatting error or what. The basic script is just recorded using the Advanced Filter function. My problem is where I am trying to creat the range to be sorted, it is supposed to be "A2" to the last row with data in it. Any help on this would be appreciated
Sub a( Dim LastRow As Varian Sheets("StoredData").Selec LastRow = Range("A65536").End(xlUp).Ro Range("A2" & ("A" & LastRow)).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( "H1:H2"), CopyToRange:=Sheets("SendToFlightProgram").Range(" A1:G1"), Unique:=Fals End Su Thanks Jim Stephens |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
| Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
| formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| how to? set my range= my UDF argument (range vs. value in range) [advanced?] | Excel Programming | |||
Threaded Mode
