Find and loop through rows

LibbyB Published at Dev

LibbyB

In my spreadsheet, in the first column one row contains a "!". I need to:

find the cell which contains !
loop through that row
if the cell in the row starts with the letter G, clear the contents.

sub looprow()

Cells.Find(what:="!").Activate

for i = 1 to ActiveCell.End(xlToRight).Column
If left(Range(ActiveCell.Offset(0,i)).Value, 1) = 'G' Then 
       Range(ActiveCell.Offset(0,i)).ClearContents
       Next
end sub

Clearly this doesn't work but as I'm new to vba not sure how to fix this, how do I loop through the row??

ricardogerbaudo

Try this:

Sub LoopRow()

    Cells.Find(what:="!").Activate

    For Each r In Range(ActiveCell, ActiveCell.End(xlToRight))
        If Left(r.Value, 1) = "G" Then
           r.ClearContents
        End If
    Next r
    
End Sub

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2022-08-16

Comments

0 comments

How to loop through all rows in DataTables jQuery?

How loop through all rows of a jtable

Loop through rows and count based on table name

How to loop through data with empty rows with VBA?

python loop through number of rows at a time

Find and loop through rows

Find and loop through rows

pump.io port in URL

How to import an asset in swift using Bundle.main.path() in a react-native native module

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Inner Loop design for webscrapping

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on '127.0.0.1:3306' (111 Connection refused)

Removed zsh, but forgot to change shell back to bash, and now Ubuntu crashes (wsl)

ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements

How to run blender on webserver?

Resetting Value of <input type="time"> in Firefox

Converting a class method to a property with a backing field

Ambiguous use of 'init' with CFStringTransform and Swift 3

Execute ./script.sh with a crontab

How to set tab order for array of cluster,where cluster elements have different data types in LabVIEW?

How to pass data to the ng2-bs3-modal?

Retrieve Element Tag Value XML Using Bash

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

SQL Server : need add a dot before two last character

Making Array From Page Elements in jQuery

Laravel's ORM sync with timestamps doesn't update timestamps

Do animations stop css changes after animation completion?