hide cloumns

  1. R

    Macro to hide columns and provde an active cell in column Bs next blank cell upon opening the workbook

    Hi,I'm having some problem figuring out why the following code is not working. When I open my file, I want a macro to automatically hide columns G -Z if they were unhidden when the file was last saved. And I want the active cell to be the next open cell (or blank cell) in Column B (starting...
  2. F

    Define Columns to print VBA

    Hi, I have the below Macro to route through my Spreadsheet and only print the sheets with data in a certain cell: Sub CHECKSHEET() Dim Sh As Worksheet Dim Arr() As String Dim N As Integer N = 0 For Each Sh In ActiveWorkbook.Worksheets If Sh.Visible = xlSheetVisible...
  3. S

    Hide column based on string

    I’m new to both VBA and this forum, so forgive me if I’ve committed any blunders. On a daily basis I receive a spreadsheet with the strings “Yes” and “No” in the cells of Column X. I would like to hide Column X if it contains any value other than Yes. What I’ve got below will run in my test...
  4. T

    Hide Columns Based on Agreement with Raw Data Table

    I am pulling raw survey data in to Sheet1 and want to write a code make a dynamic table in Sheet 2 so that it only includes the columns that are relevant to the respondent and hides all of the other columns. In the survey the respondents identified the industry that they operate in. This...
  5. S

    Macro hiding the wrong columns!

    I'm trying to record a macro to return my sheet to the print display. I recorded it and then edited in visual basic. Here's the code: Sub Hide() ' ' Hide Macro ' ' Rows("1:60").Select Selection.EntireRow.Hidden = False Columns("A:AZ").Select Selection.EntireColumn.Hidden =...
  6. D

    Vba - find next empty column, insert column, copy paste values & copy paste formulas

    I am creating a report that will be updated monthly then create charts with the newly pulled data. I need to create code that will: find last column that contains data copy & paste values of that column (within that same column) find the next available blank column and insert a new column copy...
  7. B

    VBA- Hide cells if X

    Hey guys, I need a create a horizontal filter, however this does not seem possible with excel 2010. Instead I have a formula in Cells C27:AF27 that returns "Y" if I want to keep the column and "X" if I want to hide the column. How can I hide theses columns with VBA if C27:AF27 are "X" Any help...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top