How to move down data?

[daniel50096230]

Hi,I would like to create a button,then I choose the row that I want the data to be move down..For example,when I choose the row 20,the data from row 21 to 30 will move down,and 31-40 will move down and so on....so that from row 21-30,there will be empty....

 

[Guanjin Peter]

Sub Macro1()
    Range("A1:N37").Cut  'change yr range accordingly
    Range("A10").Select
    ActiveSheet.Paste 'assume row 10 onwads

End Sub

 

[daniel50096230]

Ok...thanks..I will try on it...

 

[daniel50096230]

Makrini,I had send the file to you through pm..Hope you can help me out...Anyway,thank you very much for helping me alots....

 

[Makrini]

The file is full of Excel version 4.0 Macros which are taking full control of the workbook - I would say start a new workbook...

 

[daniel50096230]

So you means I should not using this version of macros???Ok,I will try to create a totally new workbook...Anything I will just let you know....:D...

 

[Makrini]

http://support.microsoft.com/kb/109976

gives you an indication..

It is an entirely different programming language designed for older versions of Excel

You will find it much easier with VBA and a clean workbook

 

[daniel50096230]

Ok...Thanks...I will have a look on it...Thanks....Anything can I still asking your opinion?

 

[Makrini]

of course

I wouldn't come here if I didn't like to help people (I feel like I owe it to the gurus who have always helped me when I need)