I need to delete the row in column B if the name has small case letter. For example in JOHN abraham , abraham is in small case...
I am working with some macro's in VBA and i am a little stuck. VBA is still new to me and im not entirely sure what im doing. I was given help with code for 2 different worksheet changes, but now i have 1 sheet, where i need to have both the codes working together (combined). This...
I have macro where I'm opening workbooks and for diffrent sheets I want to run code.
Set wb = Workbooks.Open(strPath2 & strFile2)
Dim myArray() As String
Dim myCount, NumShts As Integer
NumShts = wb.Worksheets.Count
ReDim myArray(1 To NumShts)
For myCount = 1...