Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to get the below macro to perform a certain operation on a series
of worksheets in my workbook, but I don't want anything done to Sheet1. For some reason, the code only performs the operation on Sheet1. This is the opposite of what I want. Can someone please help out? Sub Math() Dim LastRow As Long Dim c As Variant Dim sh As Worksheet For Each sh In Worksheets If (sh.Name) < "Sheet1" Then Rows("1:1").Select Selection.Font.Bold = True LastRow = Cells(Rows.Count, "F").End(xlUp).Row For Each c In Range("F2:F" & LastRow) If c.Value < "" Then c.Offset(, 19).Value = "=RC[-17]*RC[-2]" End If Next c End If Next sh End Sub Regards, Ryan--- -- RyGuy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated | Excel Programming | |||
Copy from file1 sheet1/file2 sheet1 last blank row | Excel Programming | |||
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') | Excel Worksheet Functions | |||
Sheet1.Activate vs Sheet1.Select | Excel Programming | |||
Why Sheet1 is displayed in modules as sheet1 | Excel Programming |