Previous Topic Next Topic

Copy filtered table columns in VB

Closed
Greg - 15 Apr 2010 à 02:02
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 15 Apr 2010 à 07:23
On change of cell content in Sheet2:A1 from defined list, I want to filter a table in Sheet 1 and then copy the contents of a column from the filtered table to a location on sheet 2. I can filter the table with OnChange but cannot get a copy / paste with range to respond.

Related:

2 responses

Réponse 1 / 2
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
15 Apr 2010 à 07:23
use the proerty
specialcells(xlcelltypevisible)

see help under specialcells in vba help
Réponse 2 / 2
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
15 Apr 2010 à 07:23
Could you please upload a sample file on some shared site like https://authentification.site and post back here the link.