I searched and couldn't find anything with regards to formatting in Excel, but if I have a simple bubble sort:
If Cell1 > Cell2
Temp = Cell1
Cell1 = Cell2
Cell2 = Temp
End If
Is there any way to shift over the cell formatting, specifically both background color and font color...
Having issues getting the program to recognize the series collection name for a graph:
Count = 1
For Each wSheet In Worksheets
If wSheet.Name <> ActiveSheet.Name Then
Count = Count + 1
ElseIf wSheet.Name = ActiveSheet.Name Then
Exit For
End If
Next wSheet...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.