+ Reply to Thread
Results 1 to 2 of 2

Referencing the next empty cel in a specific row starting at a specific point

  1. #1
    Registered User
    Join Date
    08-30-2015
    Location
    arizona
    MS-Off Ver
    2010
    Posts
    4

    Referencing the next empty cel in a specific row starting at a specific point

    Hello,
    I will try to explain this as simply as I can.
    I have a user form that finds a specific row based on a code number input into a text box. Then offsets 12 cells to the right. Then an amount from another text box in that same user form is placed in that cell.
    This is the code as it is written now:

    Please Login or Register  to view this content.
    What I need to do is to change the "offset" value from 12 to the next blank cell, to the right, in that specific row starting at column "N"

    I would appreciate any help you can give.
    Thank You
    T.
    Last edited by Toddiman; 10-04-2015 at 08:08 PM.

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,411

    Re: Referencing the next empty cel in a specific row starting at a specific point

    Hi,

    As per forum rules, please use code tags around your code...

    With that being said, here's a suggestion:`
    Please Login or Register  to view this content.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data not starting from specific row
    By biznez in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-13-2015, 02:14 AM
  2. Replies: 0
    Last Post: 03-29-2015, 08:11 PM
  3. [SOLVED] Clear contents of specific cells on the same row if a specific cell on that row is empty
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2014, 01:48 PM
  4. Replies: 0
    Last Post: 10-23-2012, 04:59 PM
  5. Replies: 2
    Last Post: 06-27-2011, 10:47 PM
  6. Replies: 5
    Last Post: 09-30-2010, 01:50 PM
  7. Define a dynamic range from a specific starting point in a list
    By gwh_lbh@swbell.net in forum Excel General
    Replies: 3
    Last Post: 08-19-2005, 09:05 AM

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