Special vba function to copy paste special function for visible cells

[rizwan.planning]

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

 

[DILIPandey]

Hi Rizwan,

So A will be top left cell and B will be top Right cell ?


Regards,
DILIPandey