Results 1 to 3 of 3

Thread: Help

  1. #1
    New Lounger
    Join Date
    Jun 2015
    Posts
    13
    Thanks
    11
    Thanked 0 Times in 0 Posts

    Help

    Hi,

    I want to create a macro that my work easier formatting of cells in an Excel sheet. The requirement is that each cell contents include the following values:

    81, 82, 83, 121, 123
    and the last digit to be formatted as an exponent. To do this, initially I want to write in cell numbers from 1 to 5 (each digit corresponding to a format of the table), these figures will then be replaced by macro values to be taken from a sheet.

    Can you help me?
    Best regards!for replace3.xlsm
    Last edited by doru.ditu.3; 2015-06-06 at 13:43.

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts
    What is the relationship between 4 and 12^1 then 5 and 12^3? Are these powers or just superscripts to reference a notation?

    If they are only superscripts, you could write: ="8 "&"1" but enter the 1 as ALT+0185
    For the 2nd superscript, use ALT+0178 and for the 3rd use ALT+0179.

    Then you can reference those cells in the other two sheets.
    Last edited by kweaver; 2015-06-07 at 20:45.

  3. #3
    Super Moderator
    Join Date
    Jun 2011
    Location
    New England
    Posts
    4,745
    Thanks
    171
    Thanked 648 Times in 571 Posts
    Reposted and answered in Visual Basic for Apps: I need macro excel for find a condtion value into range and replace a value from another sheet

    Please don't ask the same question in different places.

Posting Permissions

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