+ Reply to Thread
Results 1 to 2 of 2

Help inputting a function into a series of cells in Visual Basic

  1. #1
    Registered User
    Join Date
    01-31-2012
    Location
    Washington DC
    MS-Off Ver
    Excel 2010
    Posts
    19

    Help inputting a function into a series of cells in Visual Basic

    Hi. I am very new to using Visual Basic but I am hoping someone can help me in inputting my function into cells on multiple sheets so that the user can input data in the cells but won't interfere with the function. I have a IF(ISBLANK function that I would like to use on cells K211:K261. How can i write the code for this to put in Visual Basic?

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: Help inputting a function into a series of cells in Visual Basic

    For this work, you do not need VBA. See the example attached.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1