Results 1 to 3 of 3

How to retain cell format while using VBA?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-01-2022
    Location
    India
    MS-Off Ver
    Home 2021
    Posts
    964

    How to retain cell format while using VBA?

    Hi all,

    Hope all are well.

    In the attached file, I am using macro "Analysis" which is not concerned with columns S and U. Despite that, the macro changes the cell format to scientific. Consider these columns in row 13, 14 for example.

    Can someone please help with the correction of code? Thanks in advance.

    Pass: EUFMDAlerts2021
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Retain format of merged cell filter for new data added to w/s
    By DevfromCorrie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-18-2024, 04:00 PM
  2. Retain format of merged cell filter for new data added to w/s
    By DevfromCorrie in forum Excel General
    Replies: 4
    Last Post: 06-06-2024, 05:27 AM
  3. [SOLVED] How to retain the Destination cell format after data is copied into the cell
    By Excel987 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-03-2021, 08:23 AM
  4. Retain time format whilst formatting cell to text?
    By y_not in forum Excel General
    Replies: 2
    Last Post: 11-03-2016, 11:17 PM
  5. [SOLVED] Retain Format when refering to another Cell
    By hemants in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-20-2010, 11:57 AM
  6. Retain color/format from ws1 to ws2
    By Bevbarker in forum Excel General
    Replies: 2
    Last Post: 04-29-2008, 07:33 PM
  7. Retain date format in cell
    By Jan 2HW in forum Excel General
    Replies: 1
    Last Post: 08-09-2006, 02:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1