subscripts

  1. JenniferMurphy

    Is there any way to emulate non-numeric subscripts in VBA?

    I need to tally some results for tennis players. Is there any way in Excel to emulate an array with non-numeric subscripts? If I am reading data from a table with results for "Eliza", "Susie", and "Molly", can I get the effect of an array with these names as subscripts? I am looking for the...
  2. K

    change font of specific character

    I use a lot of subscripts in excel and I need this process automated. I already have it automated but the problem is sometimes the subscripts appear in font Openproofbold which is great and beautiful but other times the subscripts appear in Noteworthybold font which is ugly and I have a very...
  3. T

    Detecting Super/Subscripts

    So I have symbols that I have to convert to LaTeX values. I thought I would be able to run my program for replacement and then use Word to format the super/subscripts using _{^&}. I know that isn't elegant, but I need this by Friday and it would work. Well, when I ran my program, it changed...
  4. T

    Maintaining Superscript and Subscript format when using Replace

    So I have to take symbols for electronic components (like CK and CK#), and I have to come up with a program that formats them in Latex. I typed in the original symbols to be formatted in separate columns in Excel. Then I created a column next to each column of the original symbols. What I am...
  5. M

    VBA - Making new folder in directory

    Hi all, after much lurking I'm here with a real question. I'm trying to use VBA to create a new folder named after the client, then save an excel file in that new folder. I'm able to create the folder, but my folder name output is not what I was expecting (it's coming out as a 10 digit number...
  6. L

    cell referencing

    I would like to be able to reference the contents of one cell into another without losing such formatting as subscripts and superscripts, italics, etc. Currently, if cell A1 contains a string of characters with a superscript or subscript and I reference it into cell A2 using =A1 or =$A$1, the...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top