Results 1 to 1 of 1

Thread: VBA code to copy formula =0 cells as blanks

  1. #1
    Neophyte sushantsheopori's Avatar
    Join Date
    Oct 2019
    Posts
    1
    Articles
    0
    Excel Version
    2016

    Exclamation VBA code to copy formula =0 cells as blanks



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

    Hi,
    Currently using simple macros:
    Code:
    Sub PasteasValue()
    Selection.PasteSpecial Paste:=xlPasteValues, SkipBlanks:=True
    End Sub
    Objective:
    Copy data in C36 to CD39 from Room Data Tab and paste under BAR Tab ( Because of formula in each cell of room data tab - excel is not picking the cell to be blank but rather taking value as 0)
    Same then needs to be done for value in C40 to CD43 and paste under CONS Tab

    Need a way to modify this code to pick 0 as blank and I can paste it as value and skip blank as well.
    Attached Files Attached Files
    Last edited by p45cal; 2019-10-25 at 10:27 PM.

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
  •