Search results for query: *

Thank you . You have answered my question, that Excel does NOT record keystrokes it actually records what you have done and translates that into VBA. I'm sure that earlier versions used to record keystrokes or maybe it was Quattro or Lotus 123!!! Cheers Alan

Is it possible to record a macro in excel that you can call to perform the exact same keystrokes you recorded. I want to edit part of the data in the certain cells. Example: I would like the macro to do the following: F2 Home Right Right Right \Alan Delete Delete Delete Enter When I record the...

Hi Geoff I was playing around with your code If Target.Column <> 1 Then Exit Sub Target.Offset(0, 1).Value = CDec(Now()) Target.Offset(0, 1).NumberFormat = &quot;dd/mm/yy hh:mm&quot; and found if I deleted 'CDec'it gives me the correct format New Code: (I also removed time) If Target.Column...

Hi Geoff Tried your new code but returns Run-time error '1004': Application-defined or object-defined error I copied and pasted your code to ensure I didn't type it wrong As I said earlier I can use your code revesing the date format, unless your like me and hate it when things don't do what...

Geoff - It is not a problem as I will use your code with the date format as mm/dd/yy to get the correct date inserted into the spreadsheet. You stated in your reply thet you got the correct date when you tried BUT you typed 08/07/03!!! You should have got 07/08/03 if you tried it yesterday...

Thank you xlbo (Geoff) your suggestion works a treat. I have managed to work out the changes to relate it to the necessary cells in my spreadsheet. &quot;I tested your code 7 August 2003&quot; I do however have a question, the line in your code which specifies the date format (dd/mm/yy), if I...

What I am trying to acheive is when reference Cell (A1,A2,A3 etc)has Data inserted, the date the data was inserted is recorded automatically (B1,B2,B3 etc)

I am trying to automate the date entry into a cell conditional to the contents of a different cell. I can use the formula in cell B1 =IF(ISBLANK(A1),&quot;&quot;,NOW()) which puts the current date into B1 as I require BUT when I use the spreadsheet on another day the date in B1 will be changed...

Sorry I didnt advise everyone !! The problem was a faulty powerpack, sourced a replacement and now everything is sweet. Except for having to contstantly reset the Digitizer !!!

Digifix v1.2 http://www.copera.com/dowload.html Hope it helps

Can anyony help me my Palm x will not charge in its cradle. All the plugs are connected but the battery is nor recharging. I just bought the unit secondhand, the Hot-Sync operation is working correctly. The cradle does not appesr to have an indicator light on it (there is an opening to the right...