You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.
Another thing to consider is not using merged cells....especially when sorting or filtering.
Instead, highlight the cells to be merged then use>>Format cells>>Alignment>>Horizontal sropdown>>"Center across Selection"
It will appear to be merged, but won't affect other actions.
Hi Gerald, so what I mean is where I wrote "merged" (C2:D4 in my example)....In excel I've hit merge & Center so all those spaces are actually just one...I just didn't know how to demonstrate that in a thread. When I filter for numbers 1 & 3 it hides row 2 and makes the merged space smaller. Basically i want this merged spaced to be like a textbox that doesn't change regardless of what i do my data. I can't make it a textbox because I have a formula in that merged area.
If you are willing to take the good advice of the previous helpers, you could use this to change all the merged areas to center across selection.
If you're not sure, try on a copy of your original first.
Dim c As Range
For Each c In ActiveSheet.UsedRange
If .MergeCells Then
.HorizontalAlignment = xlCenterAcrossSelection