formats

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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?