Special vba function to copy paste special function for visible cells

rizwan.planning

New member
Joined
Nov 15, 2013
Messages
4
Reaction score
0
Points
0
HELLO ALL,
I need your help ,
I was trying to assign the cells numbers to long value in vba
for example if i selected $D$2:$H$33

i want to assign cells $D$2 to A
and $H$33 To B

remember $D$2:$H$33 is variable it depend upon user selection
i want to create loop such that it will select each visible cell in different rows and different columns and copy it and past it on same cells

this exercise i am doing to create a special function for copy and pasting the visible cells only to which i had applied formula
please help me
Regards
Rizwan Khan
 
Top