Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-17-2023, 07:31 PM
Logit Logit is offline Why Are Both Of These Macros Not Filling Col B On All Sheets ? Windows 10 Why Are Both Of These Macros Not Filling Col B On All Sheets ? Office 2007
Expert
Why Are Both Of These Macros Not Filling Col B On All Sheets ?
 
Join Date: Jan 2017
Posts: 587
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default Why Are Both Of These Macros Not Filling Col B On All Sheets ?

Code:
Sub cpyDte()

         Dim WS_Count As Integer
         Dim I As Integer

         ' Set WS_Count equal to the number of worksheets in the active
         ' workbook.
         WS_Count = ActiveWorkbook.Worksheets.Count

          'Begin the loop.
         For I = 1 To WS_Count
            'With ActiveSheet
            Dim c As Range
                For Each c In Range("A2:A350")
                    If c.Value = "private" Then
                        c.Offset(, 1) = "600"
                        c.Offset(, 2) = "0"
                    End If
                Next c
            'End With
         Next I

      End Sub

'ActiveSheet.


Sub SortIt2() 'VBA macro to Loop through sheets and sorts Cols A:E in Ascending order.
Dim ws As Worksheet

For Each ws In Sheets 'Start of the VBA looping procedure.
Dim c As Range
                For Each c In Range("A2:A350")
                    If c.Value = "private" Then
                        c.Offset(, 1) = "600"
                        c.Offset(, 2) = "0"
                    End If
                Next c
Next ws
End Sub

Attached Files
File Type: xlsm Replace3.xlsm (22.0 KB, 4 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Refuses to Allow Macros, even when All Macros Enabled devlon Word VBA 3 10-04-2022 02:15 PM
Why Are Both Of These Macros Not Filling Col B On All Sheets ? Force a user to enable macros in Powerpoint? Hide sheets until the "enable" button is clicked copleyr PowerPoint 1 10-07-2016 01:15 AM
Why Are Both Of These Macros Not Filling Col B On All Sheets ? How to automatically enable the macros upon opening a file with macros? laurieli Office 7 01-17-2016 08:56 AM
How to manage some sheets and sub-sheets? tesoke Excel 6 11-15-2015 04:54 AM
Linking sheets to fetch transactions from sheets to another waqer Excel 4 09-01-2011 12:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft