| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 22681 | 2002-07-27 05:27:00 | Excel macros | camac (1228) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 65960 | 2002-07-28 02:55:00 | Thank y'all for your help. That does the trick I have in the past "written" a few macros (back when 123 was king) but not lately. In the meantime they have introduced this "record" thing and the VB. Changed the language. Frustrating when you know you can do it but can't find the right word. again thanks |
camac (1228) | ||
| 65961 | 2002-07-28 03:34:00 | Cool. Its just a matter of getting used to new keywords I suppose. It's quite good having recorded macros as it writes most of the code for you and you just need to edit it to get around certain things - like moving down one cell :-) cheers Parry |
parry (27) | ||
| 65962 | 2002-07-28 21:16:00 | I always get nervous with things like invoices in Excel. Cock it up and people lose money, and that can be scary. Bad enough when using proper invoicing system. Sorry, the accountant in me can't help it (I mostly keep him locked up). robo. |
robo (205) | ||
| 65963 | 2002-07-28 21:37:00 | Use Range("startcell").End(XlDown)(2) This will go to the next cell below the last cell. |
Russell D (18) | ||
| 65964 | 2007-10-17 03:38:00 | good day... i need help on this macro thingy! :help: i'm importing data from a .txt file that will be in sheet 1. These data will always be changing. from there, i need to copy dates and figures to sheet 2 with formulas. 1) for a date in sheet 1, say cell C3, how do i create a macro that will paste to sheet 2 cell A6 and go to the next empty cell? 2) and from the next empty cell, repeat point 1 and go to the next empty cell and so on... Thks |
nana (1229) | ||
| 65965 | 2007-10-17 06:39:00 | Hi nana, and welcome to PressF1. I can't help with your problem, but if you started a new thread, instead of piggybacking on a 5 year old one, you'd have a much greater chance of getting help. ;) | wratterus (105) | ||
| 65966 | 2007-10-18 00:20:00 | haha.. dont really know how to use forums.. thks wratterus :thumbs: | nana (1229) | ||
| 65967 | 2007-10-18 01:07:00 | If you want to start a new thread, go to this (pressf1.pcworld.co.nz) page. Click the "New thread" button on the top left. ;) | wratterus (105) | ||
| 65968 | 2007-10-19 05:16:00 | Thks Wratterus!!! | nana (1229) | ||
| 1 2 | |||||