| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for new column
Hi, I want a way of automatically inserting a new column from whicheve cell is selected. I know how to do this, but everytime I do it I hav to work my way down the colum formatting the cells to how I want the to look. I have taught myself how to create a macro that does thi procedure for me, but it always runs it from the same cell, and not th cell that is currently selected. Essentially I'm setting up a Register/Mark Book in Excel and want t add colums for additional data as and when I need them. So the column need to be entered from different places each time. Sorry, if I'm not explaining this very well, but if anyone can deciphe what I'm trying to say and has a suggestion then I would be incredibl grateful. Thanks, Mark -- mevett ----------------------------------------------------------------------- mevetts's Profile: http://www.excelforum.com/member.php...fo&userid=2913 View this thread: http://www.excelforum.com/showthread.php?threadid=48879 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro for new column
Sorry, but I'm a bit of a numpty! What's is activecell? -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=488798 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro for new column
the active cell
-- Don Guillett SalesAid Software "mevetts" wrote in message ... Sorry, but I'm a bit of a numpty! What's is activecell? -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=488798 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro for new column
Sorry, I know it's a pain with a newbie! Do you mean that 'activecell' is a form of command in macro language?! If you do then I'm not sure how to integrate the command into the macro so it works. Could you possibly explain in layman's terms? Thanks for your time, Mark. -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=488798 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro for new column
As always, post your coding efforts for comments.
-- Don Guillett SalesAid Software "mevetts" wrote in message ... Sorry, I know it's a pain with a newbie! Do you mean that 'activecell' is a form of command in macro language?! If you do then I'm not sure how to integrate the command into the macro so it works. Could you possibly explain in layman's terms? Thanks for your time, Mark. -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=488798 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ron DeBruin Macro - Moving Sheet Name from Last Column to Column A | Excel Worksheet Functions | |||
| Macro - Insert&Label Column, if the labeled column doesn't exist | Excel Programming | |||
| Need Macro to Find Column Heading -- if none, then insert new column | Excel Programming | |||
| macro to transpose cells in Column B based on unique values in Column A | Excel Programming | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Hybrid Mode
