| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with offset sort function
I have used some code that was established on a previous question concerning
sorts and it works great except for the following: ActiveCell.Offset(0, 12).Insert shift:=xlDown. This will only shift down one column and I need it to shift a series of columns down. I know it is prbably something simple and I know just enough to make me very dangerous, but can someone help me? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need help with offset sort function
ActiveCell.Offset(0, 12).Resize(,n).Insert shift:=xlDown
where n is the number of columns -- HTH RP (remove nothere from the email address if mailing direct) "Cliff L" wrote in message ... I have used some code that was established on a previous question concerning sorts and it works great except for the following: ActiveCell.Offset(0, 12).Insert shift:=xlDown. This will only shift down one column and I need it to shift a series of columns down. I know it is prbably something simple and I know just enough to make me very dangerous, but can someone help me? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need help with offset sort function
Thanks Bob it works great!
"Bob Phillips" wrote: ActiveCell.Offset(0, 12).Resize(,n).Insert shift:=xlDown where n is the number of columns -- HTH RP (remove nothere from the email address if mailing direct) "Cliff L" wrote in message ... I have used some code that was established on a previous question concerning sorts and it works great except for the following: ActiveCell.Offset(0, 12).Insert shift:=xlDown. This will only shift down one column and I need it to shift a series of columns down. I know it is prbably something simple and I know just enough to make me very dangerous, but can someone help me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort by Large, Offset from Match, Duplicate values problem | Excel Discussion (Misc queries) | |||
| large function result as reference for offset function | Excel Discussion (Misc queries) | |||
| XL2002 - OFFSET function and LARGE function | Excel Worksheet Functions | |||
| How to read offset cells from dynamic sort array formula? | Excel Discussion (Misc queries) | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Linear Mode
