Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofill variable lenght column w/ sequential numbers using VBA
Problem: Sort data contained in an area defined by X number of columns and Y
number of rows, then sort the data back to its orginal row order. Normally: Before the initial sort, add an extra column and assign a unique number to each row. Sort using this extra column will restore the original row order. I can record a macro and display the VBA code without a problem. Question: Write the code identifying the last sort row when # of rows not constant. eg: Selection.AutoFill Destination:=Range("F5:F??"), Type:=xlFillDefault. I can count the # of rows, but how do I store that number, then pass it to the Range requirements? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill a column with sequential numbers | Excel Discussion (Misc queries) | |||
Fill a column with sequential numbers | Excel Discussion (Misc queries) | |||
String parsing with variable lenght strings | Excel Worksheet Functions | |||
how do I autofil a column with sequential numbers? | Excel Discussion (Misc queries) | |||
AutoFill with Non-sequential Cell References ? | Excel Worksheet Functions |