-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
cellsrowcount
-
C
Within an IF statement, populate an array with values
Hi, I've got a very basic if statement in VBA that color codes cells and writes text in an adjacent cell when conditions are met. The code is as follows and works exactly as I need: If Cells(rowCount, 15).Value = Cells(rowCount - 1, 15).Value And Cells(rowCount, 16).Value <> Cells(rowCount...- cfdh_edmundo
- Thread
- 15.value 16.value array cellsrowcount statement
- Replies: 4
- Forum: Excel Questions
-
C
If cell values are present in an array
Hi, I have the following code below which works exactly as I want it to: If Cells(rowCount, 1).Value = Range("D2").Value And Not IsEmpty(Cells(rowCount, 1).Value) Then Cells(rowCount, 14).Font.Color = vbRed End If But now I want to the = Range("D2").Value section. Instead of if...- cfdh_edmundo
- Thread
- 1.value cell cellsrowcount feearray ranged2.value
- Replies: 4
- Forum: Excel Questions
-
R
VBA Question about Skipping Rows - HELPppppp
I have a row count of 13 Can I skip rows 7 & 8? How would I code that up in Visual basic? Sub Worksheet_Activate() rowcount = ActiveSheet.UsedRange.Rows.Count Range(Cells(9, 1), Cells(rowcount, 13)).Select Selection.Sort Key1:=Range("F9"), Order1:=xlAscending, _...- RudeBoy
- Thread
- 13.select cellsrowcount end rows selection.sort
- Replies: 0
- Forum: Excel Questions
