Results 1 to 2 of 2

Thread: Special vba function to copy paste special function for visible cells

  1. #1

    Special vba function to copy paste special function for visible cells



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Hi Rizwan,

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


    Regards,
    DILIPandey

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •