[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Re: Moving Rows (Basic VBA Stuff

Niek Otten

12/11/2006 7:21:00 PM

Please fix your system date. You're messing up the newsgroups sorting.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"None" <erobins@charter.net> wrote in message news:rnp4q25nfdcuq58a1ogp41pvk3uuu72j3k@4ax.com...
| Rather than cut and paste rows, if there a way to select a range of
| cells and just move them up or down a set number of rows? (I say a
| range of cells, because on some sheets each record may contain more
| than one row of data) The Pseudo code below gives an idea of the
| context of what I am doing. The * line is the one in question. IF cut
| and paste is the best way, could you post the cut and paste method?
|
| Compare code
| IF need to move up THEN
| SELECT Rows for this Record.
| *MOVE SELECTED Range up or down # of rows. *
| END IF
|


1 Answer

Gary Keramidas

12/11/2006 7:52:00 PM

0

they have next year's date on their post and it shows up at the top of the list
in oe. i just deleted both of them from my pc.

--


Gary


"Jim Jackson" <JimJackson@discussions.microsoft.com> wrote in message
news:BB878B56-7F4B-45D5-A041-3C903B382B34@microsoft.com...
> What are you talking about?
> --
> Best wishes,
>
> Jim
>
>
> "Niek Otten" wrote:
>
>> Please fix your system date. You're messing up the newsgroups sorting.
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>> Microsoft MVP - Excel
>>
>> "None" <erobins@charter.net> wrote in message
>> news:rnp4q25nfdcuq58a1ogp41pvk3uuu72j3k@4ax.com...
>> | Rather than cut and paste rows, if there a way to select a range of
>> | cells and just move them up or down a set number of rows? (I say a
>> | range of cells, because on some sheets each record may contain more
>> | than one row of data) The Pseudo code below gives an idea of the
>> | context of what I am doing. The * line is the one in question. IF cut
>> | and paste is the best way, could you post the cut and paste method?
>> |
>> | Compare code
>> | IF need to move up THEN
>> | SELECT Rows for this Record.
>> | *MOVE SELECTED Range up or down # of rows. *
>> | END IF
>> |
>>
>>
>>