Change from Entirerow to Column range

Hi Experts,

I'm struck!!! I have below piece of code that copies entire row while copying from one worksheet to other. I need only selected column in row to be copied. Provided the whole code where click on button indi will copy the data to new sheet based on filter in selection combo box selectmember.

Any Help on same is very much appreciated

Please Login or Register  to view this content.

maybe change to

Please Login or Register  to view this content.

Hi Kalak,

Currently suppose I have data as below:

Row\Column A B C D E
Row1 ID1 20 30 40 50
Row2 ID2 70 80 90 100
Row3 ID1 120 130 140 150

Now if I select ID1 in my selectMember box and click on indi button, all rows of column A,B,C,D and E get copies to new excel as below.

Say below:

Row\Column A B C D E
Row1 ID1 20 30 40 50
Row2 ID1 120 130 140 150

But I need only Column B, C and E only to be copied as shown below:

Row\Column A B C E
Row1 ID1 20 30 50
Row2 ID1 120 130 150

Can you please let me know how to make the code change for same?

please help us in this regards at earliest.

Hi All,

I was able to solve the issue on my own..

Solution is:

Set FiltRng = rng.SpecialCells(xlCellTypeVisible).Range("A:N,V:AD")

Looks simple, but struggled a lot

Thanks to all.