crange

Attempting to write a Comment with Sub WriteComment(r as Range, T) with r if not .Comment is Nothing Then .comment.Delete end if .addComment T end with End Sub And I call this with Dim CRange as Range Set CRange = WorkSheets(SheetName).cells(RowNumber,ColoumLetter) WriteTheComment cRange...

I have the follow script in vba: Sub ConditionalHide() Dim cRange As String cRange = Sheets(1).Range("H3") For i = 2 To Sheets.Count Sheets(i).Activate If Range("H3").Value <> cRange Then Sheets(i).Visible = False Else: Sheets(i).Visible = True End If Next i End Sub The problem is that it...

Hello, I have 3 tables and I need to get a register from table 1 to table 3 based on a choose on table 2. I need to get it automatized. This is my code at the moment. I hope you guys can help me. Option Compare Text Dim espaco As Range 'You can use this variable to get the range from row 7...