+ Reply to Thread
Results 1 to 3 of 3

Simple insert value into cell

  1. 04-06-2009, 06:24 PM #1
    eonizuka
    eonizuka is offline
    Forum Contributor
    Join Date
    03-18-2009
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2003
    Posts
    104

    Simple insert value into cell

    What I would like to do is to insert the text "Agent" into the empty cell A# immediately above the block of names if "Agent" isn't already there. I'm having trouble with the syntax... The cell A# won't always be the same as the position of the block of names varies. In this case it's A9.
    Attached Files Attached Files
    Last edited by rylo; 04-07-2009 at 01:38 AM.
    Reply With QuoteRegister To Reply
  2. 04-06-2009, 06:42 PM #2
    rylo
    rylo is offline
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Simple insert value into cell

    Hi

    Try

    Please Login or Register  to view this content.
    rylo
    Reply With QuoteRegister To Reply
  3. 04-06-2009, 06:51 PM #3
    eonizuka
    eonizuka is offline
    Forum Contributor
    Join Date
    03-18-2009
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2003
    Posts
    104

    Re: Simple insert value into cell

    Thanks Rylo. I was struggling with the syntax for about 40 minutes. I was attempting to use something like this; 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1