VBA Copy Paste from a Table Question...

[Pinaceous]

Hi All,

I'm using a simple copy paste Macro22(), below for reference, from a Table that is conditionally formatted of Worksheet(2) onto a nondescript Worksheet(9).

Sub Macro22()
'
' Macro22 Macro
'
   Application.ScreenUpdating = False
   
  
 
    Worksheets(2).Range("B11:U180").Copy
    Worksheets(9).Range("B11").PasteSpecial xlPasteValues
    
 

    Range("B11").Select
    
    
    Application.CutCopyMode = False 'Clear Clipboard
    
        
End Sub

To make a long story short, when I analyze the data, which is posted onto Worksheet(9) with the mouse's right-click 'Quick Analysis' it highlights the all of the blank cells under my pasted data for specifically Column C.

This is not what I'd expect in using:

 Worksheets(9).Range("B11").PasteSpecial xlPasteValues

:as my paste code.

So, my question is, is there anyway to further strip the supposed values of

""

that is transferring from the Table to the new worksheet to

""

??

Does anyone have any ideas??

Thanks,
Pinaceous