1. J

    Concatenate cells but keep formatting of text from source cells

    I have been trying to concatenate cells from a different master sheet into one cell for a label. the problem is that some parts of the text are bold (for allergens) and when I finish it erases all the formatting from original cell. I've tried several different macros and nothing works. Please...
  2. Character7

    Non-unique Worksheet Identifier? Perhaps?

    Good morning. Quick question - doubt I will get the answer that I want, but this forum has proven me wrong in the past. I am currently working on a project with 2 display / hud worksheets, 2 data worksheets, and 6 - 7 client worksheets. I want to find a way, without putting a "identifier" cell...
  3. F

    Cell styles

    If I create a new style in Excel, what is the best way to ensure that style formatting applies ALL of the time. Before being aware of styles, I would select all cells and change colour or font, but during insertion of rows/columns, often the formatting would revert back to the "Normal" style. Is...
  4. J

    VBA: Query refresh always runs first regardless of where it is in the code.

    I'm trying to create a macro that does the following: On theButton was clicked set theButton style =msoShapeStylePreset12 Run the query Query refresh completes set theButton style = msoShapeStylePreset14 end But, the button doesn't change until after the query has refreshed. I eve...
  5. G

    Finding each cell where a style is used

    Hello, I am trying to find each location where a style is used and SELECTIVELY replace that style (one by one, manually) with another style. I am not trying to replace all usages of one style with another style, blindly. Is that possible? Many thanks. Keith
  6. J

    Add a new style to the default excel styles

    Hello All This should be easy but I can't get it to work. I made and style in a workbook called Full Date Time. I want to have this be available in all Excel sheets I open from now on. I saved this workbook as a template file, called it Book.xltx and put it in the XLSTART file but it...
  7. kweaver

    General style question

    Wouldn't it be advisable to avoid using a lower case "L" for, say, a loop when it (l) looks too much like the number 1?
  8. G

    Macro to edit styles.xml file of workbook

    Hey pro-team! Our company has a problem with copying and pasting data dumps from our ERP system into workbooks over-and-over, resulting in compounding workbook styles to the point where multiple workbooks each month hit the excel style count max (~64,000), which causes workbook crashing and an...
  9. P

    Change the Pivot Table Style from Classic to Table Style Light 20

    Good day All, Hope all is well. Could you please help me on how I can change the pivot table style being generated by the below macro. Currently, it generates "Classic" view, and would like to change it 'Table Style Light 20'. Sub CreatePivot() ActiveWorkbook.Sheets("Pending...
  10. J

    Slicer changing chart styles

    Howdy, I am an expert in a lot of things Excel, and this is driving me nuts! I create a chart and format it the way that I want. However, when I add a slicer, it changes the chart to a built-in style. I even save the chart as a template but that doesn't work. Is there a way around this...
  11. W

    How to make a user defined table style available in all Excel workbooks

    I have a medical vision issue because of which I am able to only use a dark background. Sometimes I get Microsoft Excel workbooks which are designed to be viewed on a light background. In those cases, I have to change the colours usually using the table style feature available in Microsoft...
  12. G

    Matrix SUMIF

    Hi, What formula would be best for a "3D" style SUMIF, to allow a matrix of values to be summed, as in the example below (sorry I can't get the image function to work, so it's a link instead). James.
  13. A

    Get the contents of column A and put it in Column B overwiting a tag

    I am working with just 2 columns. I am writing a macro to get the value from column A and put it in column B, overwriting the tag style, so that row 1 appears like the following: The Regency Straight Back is a traditional ....., and do this for all rows Column A...
  14. C

    How do I apply a style like this to a pivot table?

    I have been trying to build out a spreadsheet that will digest key data from a sales report then generate a form that will identify wins and opportunities for each sales consultant individually. I have been able to sort them using splicers but it doesn't look this good. How do I apply a style...
  15. W

    How To Force: Specific Cell Text To Scroll and Style

    Hey all, new here and excited to ask questions and learn. I was searching the net and all and couldn't find any specific answer to the question as the title implies. So far I was able to learn, that if you want scrollable text in specific cell, I need to use under the Active-X section, choose...
  16. B

    Changing the font color in Normal style

    I'm trying to change the font color in Normal style. I have been able to change the default font and default size but not the default color.
  17. T

    Can I check if a Pivot Table Field is Bold?

    I'm using Excel 2007 Hi All, I want to use VBA to check if a Pivot Table Field is bold. This is the code I am using: For iLoop = BottomOfPage To TopOfPage Step -1 For Delay = 0 To 20000000 Next Delay CellSelect = "A" & iLoop MsgBox CellSelect Range(CellSelect).Select...
  18. J

    VBA comparison operator not working

    Hey all, A little background on my vba project: When the date in a cell is a past date, the cell style changes to "Bad". I am trying to code this logic: If you change a past date to today's or a future date, then change a cell in another column, but same row, to the style "Neutral". For some...
  19. E

    Shrink To Fit not working when applied through a Cell Style

    I have a worksheet that has a large amount of cells using a custom cell style to apply a number format that I change through VBA. I would also like the cell style to include the "shrink to fit" option. When I modify the cell style to include "Alignment:Shrink To Fit", nothing happens in the...
  20. M

    Digital Signature in Excel

    Dear all, My boss asked me if it is possible to insert PDF style digital signatures into an Excel file. She wanted each of those to represent "approval" of a request, for example: expense reimbursement, etc. A PDF style digital signature takes the place of a person's personal signature. I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back