hide cloumns

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

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

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

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

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

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

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