automatic text copying
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: automatic text copying

  1. #1


    I would like to do something like the following:

    type in some text in A1
    have the text automatically be copied to cell g10

    I can do this using a formula, but it leaves a "0" in g10 if A1 is blank. I'd prefer not to have the "0" there. Is this possible?


  2. #2
    New Member
    Join Date
    Feb 2002
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)


    This will help:

    It works like this:
    IF cell A1 is not equal (<>) to nothing ("") show A1 otherwise show nothing ("")

    I recommend using the IF function for many things it's extremely usefull.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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