how to change cell format using vba

  • Thread starter Thread starter March
  • Start date Start date
M

March

Hello All,

I would like to know how to change cell format using vba.

Please give me suggestion.


Thank you,

March
 
The macro recorder can be your friend. Record a macro while doing it. Then
clean it up if desired.
 
You would use the NumberFormat property for the range of cells you want to
have the same format. See the help files for the NumberFormat Property for
some examples.

Rick
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel VBA 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Data | Validation with VBA 3
Open Workbook Using VBA 3
How do I copy some cells(including formatting) and save as image fileusing VBA? 1

Back
Top