Dear all

I am finding a problem working with filtered range selection. Actually I want to populate an array with the filtered data. Here is my code that selects the filtered data but being new to array concepts, I want your help to figure out the code that could fill all the data for columns A thru J from the filtered data.

Sub intero()
Dim a, b As Single
Range("j65536").Select
a = 1
b = Range("j65530").End(xlUp).Row
Range("a" & a & ":j" & b).Copy
End Sub

Thanks in advance

Hi

arTemp = Range("a" & a & ":j" & b)

will give you a [a x b] array

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Thanks a lot Shasur for your help like always. I will give it a try tomorrow morning and will get back to you should it requires your further assistance.Cheers :)