Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Special Ranges of Cells
I have vb code that is doing a bunch of sorting crap, sorting data
pulled from a...you guessed it...database! Anyhoo, it sorts the order data by the city that the orders ship out of, so this is the information (happens to be the D column) that I use to do muh thing. Unfortunaely, it sorts alphabetically, and it wouldn't be a problem, except one stupid city is in the wrong county (all the others just magically worked alphabetically). So, As the macro rips through the sheet, it seperates by city and autosums and bolds some info, but I am trying to ge it to cut this special city (we shall name it "BOHICA-Town") and paste it at the end of the data, then go back to where it was and continue. Unfortunately, since the number of orders change every time you pull data, I need to try and figure out how to name a variable range of rows to cut and paste. But the Range feature only recognizes the A1 format...and I dun have that, because the number are variable. Anyone have an idea of how I migt be able to do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Special Ranges of Cells
Not sure I follow but can you do a search on the column it
is in (looking for the particular city (selection.find (what:=town, lookin:=xlvlaues, lookat:=xlwhole).select then with that cell cut to to the bottom rows(selection.row).cut destination:=rows(range ("A65536").end(xlup).row +1 then put it back when you finish? Not sure of the exact coding but either someone else might post a better solution or I am sure you can do a record macro to find most of the code required Jay -----Original Message----- I have vb code that is doing a bunch of sorting crap, sorting data pulled from a...you guessed it...database! Anyhoo, it sorts the order data by the city that the orders ship out of, so this is the information (happens to be the D column) that I use to do muh thing. Unfortunaely, it sorts alphabetically, and it wouldn't be a problem, except one stupid city is in the wrong county (all the others just magically worked alphabetically). So, As the macro rips through the sheet, it seperates by city and autosums and bolds some info, but I am trying to ge it to cut this special city (we shall name it "BOHICA-Town") and paste it at the end of the data, then go back to where it was and continue. Unfortunately, since the number of orders change every time you pull data, I need to try and figure out how to name a variable range of rows to cut and paste. But the Range feature only recognizes the A1 format...and I dun have that, because the number are variable. Anyone have an idea of how I migt be able to do this? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Special Ranges of Cells
<<But the Range feature only recognizes the A1 format
Not true. Try '-------------------------------------------------------------- ActiveSheet.Range(Cells(1, 1), Cells(5, 5)).Select '-------------------------------------------------------------- You can replace the hardcoded numbers with variables -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FormatCellsSpecialZip Code | Excel Worksheet Functions | |||
Format cells for special characters | New Users to Excel | |||
Name Ranges: Function to convert special characters underscores | Excel Worksheet Functions | |||
Go to Special Visible cells only | New Users to Excel | |||
How do you count (not sum) cells containing special formatting? | Excel Worksheet Functions |