Search results for query: *

Hi all I have a file with 10 sheets in it. I want to delete 4 of them, so i recorded a macro with selects the sheets ( which i want to be deleted), but when i run it, a warning message comes up asking if i want truly to delete the sheet, how can i take that warning window out ? Here what i...

Hello experts in VBA excel. I have a excel sheet, with which my coworker collects data from the different audits, he is collecting it on diagonal form (upper left to bottom right), because the columns and rows content is changing all the time ( data collection) So i would like to create a...

how to stop at the last row selection "R11C14:R10000C14" I have a sheet where i have a column with data, number of row every time is different, some time i have less data some times more, how can i stop my conditional formatting at the last row of data every time the code is going until...

I have an excel sheet and i want to highlight or select all the conditional formatting cells it is possible ? i want to see what cells contain CF

i have a workbook with 25 sheets, and each sheet has hundreds of formulas, i tried the flowing VBA code, but is is running forever, i any other way, Sub Remove_External_Links_in_Cells() Dim LinkCell Dim FormulaCells As Range Dim SheetsInWorkbook As Object For Each SheetsInWorkbook In...

Why this code is not working ?, i mean the "for loop" it doesn't like the "count if" Application.Goto Reference:="R11C16:R10000C16" Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _ "=COUNTIF(Code,P11)=0"...

test for the existence of CF condition in a loop: for =LEN(TRIM(P11))=0 the code is : Dim N As Long, i as long i = 0 For N = 1 To 9989 If rtrim(Cells(N, 16).text = "" Then i = i + 1 End If Next N if i > 0 then...

Why when i use message box for cell with no conditional formatting , the message box is displayed but when i use the the message box for conditional formatted cells, the box is not showing up.

I have two columns, with text codes, the codes in in the first column are not changing, in the second column value are permanent changing, so i need to use conditional formatting to do : when introducing values in the second column and these values don't exist in the first column, to make...

I have a for loop : Sub color2() Dim N As Long For N = 1 To 56 If Cells(N, 16).Interior.ColorIndex = 3 Then MsgBox "Codes don't Exist " End If Next N End Sub this code gives me message box for every cell whic has...

Hi, could someone help me with VB, i have a column, some cells in the column are red some are white after ruing a macro, some times no red at all - (conditional formatting ), So i want a message box to appear if i have any red cells, thank you

Hi, could someone help me with VB, i have a column, some cells in the column are red some are white after ruing a macro, some times no red at all - (conditional formatting ), So i want a message box to appear if i have any red cells, thank you