Assuming you want to format cells in each row of a worksheet using a For loop, you can use the following code:
For i = 1 To numRows
With Worksheets("Sheet1").Cells(i, 1).Resize(1, numCols)
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.Font.Bold = True
.Interior.ColorIndex = 15
.Borders.LineStyle = xlContinuous
.Borders.Weight = xlThin
End With
Next i
In this code, numRows
and numCols
are the number of rows and columns in your worksheet, respectively. The With
statement applies the formatting to the cells in each row, starting from column 1 (Cells(i, 1)
) and spanning numCols
columns (Resize(1, numCols)
). You can modify the formatting properties within the With
statement to suit your needs.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2023-01-25 11:00:00 +0000
Seen: 18 times
Last updated: Jul 08 '22
How can I print all but the first 1000 Lines from a File in Bash?
Why does my method execute only once within a while loop?
What is the method for bypassing the entire current loop if an error occurs?
How can an array of objects be initialized in C# without implementing a loop?
How can resetting a list be avoided during a loop?
What is causing fs.readFileSync() to restrict the number of simultaneous tasks in node.js?
How can a DropDownListFor be generated in a loop?
How can the legend of a Seaborn scatterplot be updated within a loop?
What are the ways to prevent an infinite loop while using setState()?
Why is every instance in the switch case being executed during a for loop?