erior.ColorIndex = 6
> End Sub
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> *From:* CAN
> *Sent:* Tuesday, July 31, 2012 9:33 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Macro is not do
uperscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = 1
End With
Range("N5").Select
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
.com
From: CAN
Sent: Tuesday, July 31, 2012 9:33 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro is not doing the right formatting - need
help
Thank you Don, you are correct. I should provide a more clear explanation of
what I need.
I have attached 2 additional files
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro is not doing the right formatting - need help
I have a simple excel sheet (attached file) The file is sorted by date and it
shows information about deposits made in a day. Sometimes a deposit might have
more than 1 transaction
I have a simple excel sheet (attached file) The file is sorted by date
and it shows information about deposits made in a day. Sometimes a deposit
might have more than 1 transaction, sometimes it is just one transaction.
The data is as follows: Date, Unit ID, Amount & Check number (there othe
