** Using Functions

		Microsoft Office Forums > Microsoft Excel > Excel Programming
** Using Functions

FAQ

Thread Tools

Display Modes

02-05-2011, 01:32 AM

macropod

Windows 7 32bit ** Using Functions

Office 2000

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Hi Rey,

You could change:

Code:

        Cells(lRow, 1).Value = GetUserName
        Cells(lRow, 2).Value = VBA.Now

to:

Code:

        If Cells(lRow, 1).Value <> "" Then
                Cells(lRow, 1).Value = GetUserName
                Cells(lRow, 2).Value = VBA.Now
        End If

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Drop Down List and Functions (Linking)	sten	Excel	0	03-17-2010 03:03 PM
Auto-updating basic math functions & cross-referencing tables	FranklinBluth	Word Tables	13	11-19-2009 10:26 AM
Automated Functions??	nickypatterson	Outlook	0	08-27-2009 01:50 PM
Merging a Word doc with VB functions contained	adamwbrown	Word	0	08-13-2008 06:10 AM
How to show help for addin functions?	Movses Asatryan	Excel	0	03-02-2006 05:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:57 PM.