#1
|
|||
|
|||
VBA to Format a Table Column in Excel
This should be most simplistic and I've tried several attempts at the code. My last endeavor: This is part of a worksheet change event if that helps, and the information is in an Excel Table. Code:
If Not Intersect(Target, Range("DataEntry[Threshold]")) Is Nothing Then With Target Application.EnableEvents = False .NumberFormat = "#,###" Application.EnableEvents = True End With End If Best weekend wishes, Sgt. Rock (Mort) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Embedded Excel in Powerpoint - custom animation, display column by column | andytheanimal | PowerPoint | 2 | 01-20-2015 06:30 AM |
How can I temporarily break a 3 column format in order to type a single column paragraph | William P | Word | 1 | 01-04-2015 06:40 PM |
Merge From Excel With Table in Word - Next Record If Excel Column Same? | misscrf | Mail Merge | 2 | 10-15-2014 11:51 PM |
1.image in a table 2.right click 3.menu click format 4.a format column appears | OldFatDog | Drawing and Graphics | 1 | 06-13-2014 11:19 PM |
Updating excel link alters table format in PP | dbmagnus | PowerPoint | 0 | 06-03-2010 12:12 PM |