Solved

How do I replace a cell value but the formatting

Posted on 2014-03-18
7
78 Views
Last Modified: 2014-03-26
I have ThisWorkbook(MySheet).Range("A4").Value = "David"

However, when the value replaces whatever was previously in "A4" I also lose the formatting.  Any suggestions ?
0
Comment
Question by:upobDaPlaya
  • 4
  • 3
7 Comments
 
LVL 39

Expert Comment

by:nutsch
ID: 39938553
This shouldn't happen, unless your cell has conditional formatting and your change of value doesn't meet the same condition as the previous value.

Or there's a worksheet_change macro at work, but it's less likely.
0
 

Author Comment

by:upobDaPlaya
ID: 39938689
How would I update a column in vba to reflect Aria 10..Note I am putting backcolor into the cell via VBA, but I am not doing any formatting..
0
 
LVL 39

Expert Comment

by:nutsch
ID: 39938708
What's aria 10?
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:upobDaPlaya
ID: 39938883
sorry arial 10... font family and size
0
 
LVL 39

Accepted Solution

by:
nutsch earned 500 total points
ID: 39938890
With columns("a").Font
.Name = "Arial"
.Size = 10
End with
0
 

Author Closing Comment

by:upobDaPlaya
ID: 39957992
Perfect !  thx
0
 
LVL 39

Expert Comment

by:nutsch
ID: 39957998
Glad to help

Thomas
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Move data from one sheet to another 11 36
Data in Rows to be converted into single row 9 40
Auto Populate Day Month  2 digit Date 4 19
Excel format formula for currency 15 24
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question