formats

Hi Peoples, I have constructed a macro to copy a column of data, paste to a new sheet and then remove duplicates. Everything worked fine until I tried to amend the code to paste just the values and not the formats. Also the remove duplicates removes the formats in the new sheet after the data...

I've spent the last three months working on this project and am getting down to the short strokes. I asked my boss to take a look at what I have today and he got an error message that there are too many formats. I found out that while I have been creating this with Excel 2010 most others in...

Hi, I want to quickly copy a range from the active sheet (A2:A500) and paste into every sheet that follows (including cell formats) but not in any previous sheets. Any help appreciated

Hi there, I would like to have a column which only accepts the following two formats to be entered; ### or ###/### Example; 499 or 499/001 I'm guessing I can do this under Data Validation??:confused: Thanks for your time!

I use Excel 2013. The option "Home > Clear > Clear Formats" does not clear the formats when a part of text string is formatted in a cell. Please find a screenshot below and let me know, is there any option available to clear formats in such cases? Thank you in advance.

Everyone I am having a two folded problem here, which i think stems from the same core issue.... First one is that for some reason, I have a chronic issue with my Excel taking one (or more) of my tabs and changing the formats of all the cells into Date formats (pic attached). This is especially...

I have been asked to copy 45 sheets into a management pack and then save this pack as .xlsx and .pdf So far so easy, but each sheet has two charts on and something happens when the sheets are copied to change all the format colours when they are pasted into the new workbook. Since the charts...

Good day guys. I'm looking for a way to list all used number formats in my workbook, along with a count of how many cells use each number format. I've tried running a loop through each cell in each worksheet, but I can't get it to work. Google has not provided any usable results :eeek: Does...

Hi What i need to do is copy and past data from one sheet to another . The issue is that i want to copy the values and formats but not the formulas. I have the folowing code Sub CopyWeekly() Sheets("WeeklyDetail").Unprotect Password:="xxxx" Range("a1:g40").Copy...

Hi all, I have a spreadsheet that I would like to use VBA to automatically format / copy and paste certain things. The spreadsheet varies in length and currently I need to do this manually which is quite time consuming. If anyone can help it would be greatly appreciated. Copy the formats...

Hi All, I have two macros, the first macro works perfectly, the second macro does not work at all (error message). What is wrong with the second macro, please. Sub This_Works_For_Workbook() MsgBox ActiveWorkbook.Styles.Count End Sub Sub This_Does_Not_Work_For_Worksheet() MsgBox...

Hi all! I'm looking for some help. I can extract a worksheet with different time formats that I would like to be able to sum, substract...etc For example here are the 2 different time formats appearing in the document: 1- 07:04:23 for 7 hours 4 mins 23 secs 2- 2.35h for 2 hours and 0.35...

Hi, my work PC has just been updated from Excel 2010 to 2016. I had a macro that worked fine before the upgrade but now when i run the macro from a button in 2016 it formats the worksheet incorrectly. However if i go into Visual Basic and run the macro step by step it formats correctly. Any...

Hi, I am using the following code to copy over only the visible cells from 1 workbook to another due to the use of a filter. However, some of these cells have formula so I need to copy over only formats and values as well. How would i do this...

Can I apply multiple conditional formats to a dynamic range of cell?

When I save a spreadsheet file to CSV, this week, it converts from 12/01/2017 to 12/17/18. I have tried saving the Dec 1 17 date in different formats but everyone yields a 2018 after reopening. Any help?

I want to combine in one cell two numbers with different formats. How to maintain the percentage format <colgroup><col span="2"><col span="2"><col></colgroup><tbody> <colgroup><col span="2"><col><col><col></colgroup><tbody> Command Result Desired display -6% 80 =B2&" "&A2 80...

Hello was wondering if anyone know how to format a cell in a way that every time I change a picture the new picture automatically re formats to the same size as the previous picture. I have multiple photographers and sometime the photo aspects are different so I have to resize manually.

I have a range of cells that contain a number of CF's and I need to remove these but retain the resulting formats. As the range can cover up to 14 columns and several thousand rows, is there a way of applying the formats at once rather than on a cell by cell basis? Currently I am using the...

So I've got this string of code that finds a sheet by name (source), then copies its data onto a combined sheet (destination) after the last row. I pulled this from google, and not quite sure yet how the syntax works w/ the copyrng and vlaues vs formats. How do I adjust this to preserve the...