Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Training on macros in Excel97 using Windows 98
British Telecom use hhhh:mm:ss time format in downloaded bills, which Excel97 does not recognise. Cannot re-format to hh:mm:ss - Excel does not recognise hhhh:mm:ss as a numeric format ??. Tried (with no experience) to create a macro but having set it up to remove first two h's from first ten entries (of 546) when I applied the macro to entry eleven, it simply replicated the values of the first ten. Can anybody tell me what to do or where I can find out more about macros than is in Excel97's "Help" section ? |
#2
|
|||
|
|||
"BT Bill" wrote in message
... when I applied the macro to entry eleven, it simply replicated the values of the first ten. This happens when your code uses absolute references rather than relative references. If you have: Range("A1") = 1 , you get 1 in A1. But ActiveCell = 1 gives you one in the cell that's selected when you start the code. If you used the macro recorder, try again. When the "Stop Recording" toolbar's visible, notice that it has a "Relative Reference" button. When you click this, everything you do from then on is recorded in relative (to the active cell) mode -- until you click it again (it toggles on & off). Post your code here if you wish ; ultimately, you'll need something *like*: For Each Cell In Selection Cell.Value = Right(Cell, (Len(Cell) - 2)) Next Cell Rgds, Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) | |||
Windows ME and Windows XP Function of key F2 is different | Excel Worksheet Functions |