Excel Add In Problem

R

Rajagopal C

Hi

I am trying to create a add in that would

1. Create a new sheet

2. based on some logic will copy data from this shhet to the new one.

a. When I ran the following piece of code it does not add a ne
worksheet.

Filename = ActiveCell.Worksheet.Name

Sheets.Add Type:="WorkSheet"
ActiveSheet.Name = "Sheet 2"

Worksheets(Filename).Activate

b. When the following piece of code is hit (line 3) it just stop
processing further.

Value = ActiveSheet.Cells(C.Row, 3).Value
Worksheets("Sheet2").Activate
Worksheets("Sheet2").Cells(Fill_Count, 1).Value = Value

Any help on this

Thanks & Regards
Rajagopal
 
Top