Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create Sheet & Copy Stuff
I'm copying and transposing a comma separated list from A1 in Sheet1
to a new sheet. The New sheet is created, but I get an error trying to paste the list. Sub AddSheet() Dim ActNm As String With ActiveWorkbook.Sheets ..Add after:=Worksheets(Worksheets.Count) End With ActNm = ActiveSheet.Name ActiveSheet.Name = "SheetW" Dim T As String, S As Variant ActiveCell.Offset(1, 0).Range("A1").Select With Worksheets("Sheet1") T = ActiveCell.Value End With S = Split(T, ",") With Worksheets("SheetW") .Range("A1").Resize(UBound(S) + 1) = Application.Transpose(S) End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to create, name sheet and copy. | Excel Discussion (Misc queries) | |||
1 Create a macro to Copy & paste certain data to another sheet | Excel Discussion (Misc queries) | |||
create copy of sheet tab (excel 2007) when opening workbook | Excel Worksheet Functions | |||
sorting and adding cells in different work sheet? (hard stuff) | Excel Discussion (Misc queries) | |||
Column has emails & other stuff. Want to create a column w/ just e | Excel Worksheet Functions |