Forum Discussion

NSK-Mar's avatar
NSK-Mar
Copper Contributor
Nov 17, 2019

Paste TO visible cells only in a filtered cells only

I want to paste a formula or value in the visible cells of a filtered column. How to go about it? Thanks 
excel
Formulas and Functions
office 365
rajm189's avatar
rajm189
Copper Contributor
Mar 30, 2023

Cangkir hi this VBA is working fine, but it’s taking time if we are using in larger number of cells, can we get quicker VBA ?

Cangkir's avatar
Cangkir
Brass Contributor
Jun 27, 2023

rajm189 

hi this VBA is working fine, but it’s taking time if we are using in larger number of cells, can we get quicker VBA ?

Sorry for the late reply.

It depends on your data.

  1. About how many rows is your data?
  2. Do you copy from filtered range? 
  3. Does your data have multiline cells?

 

Resources