Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi gang
Here's my cod Sub summary2( Application.ScreenUpdating = Tru Dim i As Intege Dim myVal As Strin On Error Resume Nex Application.DisplayAlerts = Fals Worksheets("Summary").Delet Application.DisplayAlerts = Tru Worksheets.Add(Worksheets(1)).Name = "Summary For i = Worksheets("Start").Index + 1 To Worksheets("End").Index - myVal = Worksheets(i).Range("P13").Tex If Left(myVal,2) = "F Then Worksheets(i).Selec Range("P10:p38").Cop Worksheets("Summary").Selec Range("IV1").End(xlToLeft)(1, 2).Selec Selection.PasteSpecial Paste:=xlPasteValue Selection.PasteSpecial Paste:=xlPasteFormat 'End I Next Im getting a syntax error on ....If Left(myVal,2) = "F Wheres the bug Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel: wheres menu item to change file format conversion options? | Excel Discussion (Misc queries) | |||
Wheres the bug | Excel Programming |