Home |
Search |
Today's Posts |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
visual basic
Here is a sample of the macro
' ActiveCell.FormulaR1C1 = "Matthew" Range("R2").Select ActiveCell.FormulaR1C1 = "Mike" Range("R3").Select ActiveCell.FormulaR1C1 = "David" Range("R4").Select End Sub "JE McGimpsey" wrote: It would be helpful to post the macro (or a portion of it if it's long) in your message. Trying to guess what you recorded is difficult... In article , Matthew wrote: Hi can anyone help, I want to set up a macro that will give me a list of names on a sheet eg. Matthew Mike David Etc But when I ran the macro it remembers the cell I have originally typed into and I want it to be able run from where i place my mouse eg. It could Start in cell C1 or D3 etc. Does anyone know the script i would need? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
visual basic | Excel Worksheet Functions | |||
Visual Basic and SP2 | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Visual Basic | Excel Discussion (Misc queries) | |||
Visual Basic Help | Excel Discussion (Misc queries) |