vbred

Hi, I am fairly new to excel VBA and I have tried a bunch of different methods. I am trying to highlight only column I and J, if it is not blank, but also trying to highlight the cells with different colors based on values column G. For now, the code that I have inputted makes the excel change...

Hi all I have code below to check balansheet then copy row with conditions But I thinks this code too long and run slow, could you make this code shorter Many thank Sub CheckPS_noibang()Worksheets("result").Range("A20:Z15000").Clear Application.ScreenUpdating = False Dim i As Integer, lastrow...

Hi I am trying to understand the code below which highlight blank cells. 2 parts I did not understand 1) what does this line do " Set Dataset = Selection "? 2) what SpecialCells() function does here --> Dataset.SpecialCells(xlCellTypeBlanks).Interior.Color = vbRed Thank you so much...

Can anyone help. I have my code below. We have to use GoTo, yeah I know, but I am needing my code to use the last x entered in to the input box (the correct one). Currently it is only using the first value in my calculation. We have to have it so that it continues to let the user choose until...

Need correction in code, little correction.. Error - Object doesn't support this property or method.. With Worksheets("Sheet1") For i = 3 To RowCnt1 If .HorizontalAlignment = xlLeft Then............Getting an error on this .Cells(i, 6).Interior.Color = vbRed End If Next i...

I have a dropdown list in a sheet from which the user will select a color (the 7 constants) red, cyan... In my code I wanted to simply put "vb" before it something like: xcolor = "vb" & user-selected-color cells(x,y).interior.color = xcolor But it fails to produce the color. Any ideas? Is...

I have this code, but it does not doing what I need. did search with Google, but cannot find any info is the following possible, if so how. I want to highlight say 2 rows, then it must place a border on top and bottom of the rows. The nesx one can be 4 rows and so on. the rows will always be...

Hello All, I have code here... Sheets("Cherry").Select ActiveSheet.Tab.Color = vbRed and it works fine But when I try to use the same code for "Grape" and "Purple", it doesn't work Sheets("Grapes").Select ActiveSheet.Tab.Color = vbPurple Is there a color chart for all...

This code is not doing anything. I am trying to identify Fields that the user must enter data by making the field border red is the field is Null or "". Private Sub Form_Activate() 'Check to see if PID is set to "Select-A-PID" If Me.RFPMgr_ID = 1 Then DoCmd.OpenForm...

Sub ForEachLoop1() For Each cl In Range("A1").CurrentRegion cl.Select If cl = 10 Then cl.Interior.Color = vbRed End If Next cl End Sub Sub ForeachExample2() Application.DisplayAlerts = True For Each ws In ActiveWorkbook.Worksheets If ws.Name = "Delhi" Then Else...