Groups > comp.lang.basic.visual.misc > #1262

Re: Run-time error '1004': Application-defined or object-defined error

Path	csiph.com!usenet.pasdenom.info!gegeweb.org!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail
From	GS <gs@somewhere.net>
Newsgroups	comp.lang.basic.visual.misc
Subject	Re: Run-time error '1004': Application-defined or object-defined error
Date	Mon, 09 Jul 2012 18:13:21 -0400
Organization	A noiseless patient Spider
Lines	39
Message-ID	<jtfl1v$3eu$1@dont-email.me> (permalink)
References	<5c454016-0768-4245-a2be-ddab885882cb@googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset="iso-8859-15"; format=flowed
Content-Transfer-Encoding	8bit
Injection-Date	Mon, 9 Jul 2012 22:13:19 +0000 (UTC)
Injection-Info	mx04.eternal-september.org; posting-host="UVJBuiIZprDyxzUkJsiwfw"; logging-data="3550"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18dQRl4Fnbp3hdYWHCAOwW5"
X-Antivirus-Status	Clean
X-Newsreader	MesNews/1.08.03.00-gb
X-Antivirus	avast! (VPS 120709-1, 07/09/2012), Outbound message
X-Face	G"ln~:.wBqHZznO'(lJjjprxGYAjIF7#^u)lx,@"H'F#uXm%j`T6kxat5rq092aW;K#<!y <6K)wt3HjA)V"XV`W3}QtsD['Jm:qqpgttEl^wk@9{HJglN-Q'.91Af~ySM>m4jZ(2aW$34N&B&E@ j~tjGV-aC18j1y>zi.\[ZGXsd
Cancel-Lock	sha1:Vhh6WmRbtni1M6k03CYdkwiwUDw=
X-ICQ	543516788
Xref	csiph.com comp.lang.basic.visual.misc:1262

Show key headers only | View raw

slimeph@gmail.com brought next idea :
> I have the following code and I keep getting an error at line "Set timestamp 
> = Target.Offset(0, -3)". What seems to be the problem. What I would like to 
> do is whenever cells in column C is modified, corresponding column A will get 
> timestamped.
>
> TIA,
> kray
>
> ---
> Private Sub Worksheet_Change(ByVal Target As Range)
>         
>     'MsgBox Target.Address
>     Dim timestamp As Range
>     
>      
>     Set timestamp = Target.Offset(0, -3)
>     'MsgBox timeStamp.Address
>     
>     If timestamp.Value = "" Then
>         MsgBox "Nothing in there"
>         timestamp.Value = Now
>     Else
>         MsgBox timestamp
>     End If
>
> End Sub

Uh.., Column C minus 3 falls off the sheet since column A is -2!

-- 
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
    comp.lang.basic.visual.misc
    microsoft.public.vb.general.discussion

Back to comp.lang.basic.visual.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Run-time error '1004': Application-defined or object-defined error slimeph@gmail.com - 2012-07-09 11:27 -0700
  Re: Run-time error '1004': Application-defined or object-defined error GS <gs@somewhere.net> - 2012-07-09 18:13 -0400
    Re: Run-time error '1004': Application-defined or object-defined error slimeph@gmail.com - 2012-07-10 05:36 -0700
      Re: Run-time error '1004': Application-defined or object-defined error GS <gs@somewhere.net> - 2012-07-10 11:42 -0400
        Re: Run-time error '1004': Application-defined or object-defined error "Auric__" <not.my.real@email.address> - 2012-07-10 17:03 +0000
          Re: Run-time error '1004': Application-defined or object-defined error GS <gs@somewhere.net> - 2012-07-10 13:27 -0400
            Re: Run-time error '1004': Application-defined or object-defined error "Auric__" <not.my.real@email.address> - 2012-07-10 18:26 +0000
              Re: Run-time error '1004': Application-defined or object-defined error GS <gs@somewhere.net> - 2012-07-10 16:28 -0400
                Re: Run-time error '1004': Application-defined or object-defined error "Auric__" <not.my.real@email.address> - 2012-07-10 23:10 +0000
                Re: Run-time error '1004': Application-defined or object-defined error GS <gs@somewhere.net> - 2012-07-10 21:21 -0400
              Re: Run-time error '1004': Application-defined or object-defined error slimeph@gmail.com - 2012-07-10 15:26 -0700
                Re: Run-time error '1004': Application-defined or object-defined error "Auric__" <not.my.real@email.address> - 2012-07-10 23:24 +0000

csiph-web