table styles

  1. D

    VBA for sheet design and table style options, for application to whole workbook

    Hi, Hopefully you guys might be able to advise me, I've spent most of today looking over different VBA code but I've not found anything quite like what I'm looking to do. I currently have a workbook whose individual sheets pull data from different excel workbooks on Sharepoint. When this data...
  2. M

    New Stable Style - Set For All New Workbooks

    Hi, Excel 2010 I have searched for this problem and for others that may have similar solutions, but without luck. Apologies if I have managed to miss something that will later seem obvious. I am trying to design a new table style that can then be used in all new blank workbooks. I have...
  3. Randall00

    Ok, so there's ActiveCell and ActiveSheet...but how 'bout ActiveTable?

    Hi there! This is about the ever-unfolding mysteries surrounding Tables from Office 2007 in VBA. The lovely piece of code below does a fine job of removing the Table style from Table1 and converting it to a normal range: Sub RemoveTableStyle() Dim oSh As Worksheet Set oSh =...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    • Replies: 44
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    • Replies: 35
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    • Replies: 28
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    • Replies: 24
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    • Replies: 23
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    • Replies: 23
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top