et(1, 0).Resize(266).NumberFormat = "0.00%"
End Select
End If
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Tiffany
Sent: Thursday, March 29, 2012 9:52 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Problem with Format C
Why not simply use conditional format?
Sam Mathai Chacko
On Thu, Mar 29, 2012 at 8:22 PM, Tiffany wrote:
> Hi -
>
> I'm a little new to VBA but have managed to put together a macro that half
> achieves its intended purpose.
>
> Depending on what is chosen in a data validation cell (any cell in
Hi -
I'm a little new to VBA but have managed to put together a macro that half
achieves its intended purpose.
Depending on what is chosen in a data validation cell (any cell in range S8
to AL8), the macro is supposed to change the format of 296 cells below the
data validation cell:
- If
