how to create new worksheet of selected cols or rows.

[Nitesh Khot]

hi....
how to create new excelsheet of selected cols and rows in excel.

 

[Luke M]

I'm afraid you're going to have to give more details than that for us to give an answer. All I was able to understand was that you want to create a new worksheet. What are we doing with "selected cols and rows"?

 

[Nitesh Khot]

suppose.....in my sheet1 i have data from A1:M255

Now if i select data B1:E50 then i want these data can be in another new workbook...(when executing macros)

 

[Luke M]

Are we...

• copying all of B1:E50 into a new workbook, same sheet?
• A new workbook, with new sheet for each row?
• A new workbook, with new sheet for each column?
• Should the copying happen as soon as you select the data, or do you want to run the macro/hit a button?

 

[Nitesh Khot]

the whole selected data can be copied in another new workbook ....and when click on button it nedd to be run.

 

[Luke M]

This will do what you asked.

Sub MakeNew()
Dim selRange As Range
Set selRange = Selection
Application.Workbooks.Add
selRange.Copy ActiveSheet.Cells(1, 1)
End Sub