formats

  1. W

    Styles list for workbook and their properties?

    This is for Excel 2010. Is there a way to generate a list of the styles used in a workbook, together with their properties? My intention is to help the user recognize what a style means by creating a styles key on a separate worksheet. For example, if Workbook A has 45 styles in use...
  2. V

    Range to array: how to get formats?

    Hi, I'm trying to put values and formats of cells to an array to faster process them. this seems to work dim area as variant area = range("a10:z20").value This doesn't dim areaformat as variant areaformat = range("a10:z20").font.bold Is there a way to quickly get font and .numberformat and...
  3. M

    Copy and Paste Macro

    Hello, first time posting. I wanted to create a macro to make copying and pasting formats and values easier. Here's what I want to do with the click of a button: - Copy from two tabs of active worksheet - Create new worksheet - Paste values and formats to new worksheet for each tab - Save...
  4. C

    Excel - Date Analysis

    All, I have an issue with some raw data I have. The system I am using dumps out a long list of dates which I need to analyse, however the dates it spits out are inconsistent in format i.e. some are in date format, some are in text format. Is there any formula to convert the list to a similar...
  5. K

    VBA: Adding Times/Decimals Together in Textboxes

    Hi all, I have a series of textboxes in a userform that need to be added up... the answer goes into a final textbox, which can be altered if necessary. The basic idea is "end time - start time - lunch time + travel time = total." I was using this code to achieve it, which worked fine when all...
  6. J

    Mysterious date format change - help pls!

    Hi all, From many daily reports, I copy some data into a master excel file. These data include dates with different formats, e.g. 15/10/2011 or 15/10 (date/month) or 1400/09 (time/date) or sometimes only 05 (date). All these are pasted special as values into the master file. The problem...
  7. D

    How do you create a personalized, formatted email using Excel 2007 VBA

    I am working on code (Excel 2007) that creates 200 plus emails using a template. I want to personalize the emails in Outlook 2007 (I.E. Dear John,) but also maintain formatting. I have had success doing one of the two items, but not both. If I use the generic message in the template with no...
  8. C

    Importing / exporting formats

    I am exporting the results of a query in Access to Excel using a macro to an existing file. I would like the resulting excel file to have specific row sizes and column width and a specific background color. This would be best if it could be accomplished with a single pushbutton action in...
  9. T

    How do I lock the formats of a sheet?

    How can I make a sheet keep all the formating I set up. When other user's enter data, they can paste data but that will change my formats to what ever they are pasting already has. Thanks, Tmoske
  10. S

    Add an ending zero to a bunch of numbers

    I am trying to add a zero to the end of a series of numbers. I have a list of 20,000 customer numbers, some with 5 digits and some with 6 digits. Example some are 123456 and some are 12345. I need to make them all 6 digits long, so I decided to add a leading zero to them. I made a custom format...
  11. S

    Adding a leading zero to numbers

    I have a list of a couple thousand customer numbers. Some of them are 5 digits long and some are 6. I was just told that we have to have them all the same number of digits long. So, I am going to add a leading zero to them. Example the number is 12345 I want to make it 012345. Does anyone know...
  12. X

    Conditional Format "?"

    Tried to make the conditional format =COUNTIF(AG2:AG1418,"?") Of course the issue is that it adds up not only ?'s but also Y or N (the other two possible cell entries) How can I make it just count the ?'s?

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top