xlcelltypevisible

Hi, I created a workbook which has 2 worksheets. Sheet1 contains a Students ExcelTable. Sheet2 contains a Teachers ExcelTable. I am trying to filter records in the Students Table using the following macro. When running the macro with Sheet1 active, the filtered range, rng2 is $A$1:$B$2 as...

Hey all-been working at this for a couple days and could use some input. What I'm attempting to accomplish with this code is to compare two sets of data on separate sheets(same workbook) and populate a third sheet with exceptions. I'm looking to have a list of what's missing in both of the...

Good afternoon! I am trying to come up with a way to quickly go through a large range of cells and paste the formulas (and then values over-top) to ONLY the visible rows. I feel like I am missing some small and simple thing that is keeping me from getting this to work. Any suggestions would...

Hi I am trying to working with a table where I want a Macro to i 1. Filter a table on column 2 for all entries for "Yes", 2. Set a range object for the visible cells within column 1. 3. Allow for a specific cell to be amended.within those visible cells I have the following code that works...

I am losing the last row of data when using '.SpecialCells(xlCellTypeVisible).Copy'. Since this is not a range I set, I am wondering if others have found this and have a workaround. Below are links to screenshots showing the problem: Losing NULLs 1 - Bermex's library Losing NULLs 2 - Bermex's...

Hi, I am trying to find a faster way to replace the following code. Select Case ActiveSheet.AutoFilter.Range.Columns(1). _ SpecialCells(xlCellTypeVisible).Count - 1 any suggestions pls

Quick question- If you set screenupdating to false for speed ...does that mean you cant use functions that process based upon what is visible? ...does excel keeps track of what would be visible and process off of that such that it doesnt matter what you really do see? thanks in advance!