Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro creation
I would like to create a macro that would generate a small column of words
when needed. The problem is I need the start location to vary. One day in one cell, the next day another cell. Can this be done? Sample: Word1 Word2 Word3 Word4 Column location will vary from excel sheet to excel sheet. Thanks in advance, Ric |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro creation
Rickm here is one way,
Sub test() ActiveCell = "word1" ActiveCell.Offset(1, 0) = "word2" ActiveCell.Offset(2, 0) = "word3" ActiveCell.Offset(3, 0) = "word4" End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Rick" wrote in message ... I would like to create a macro that would generate a small column of words when needed. The problem is I need the start location to vary. One day in one cell, the next day another cell. Can this be done? Sample: Word1 Word2 Word3 Word4 Column location will vary from excel sheet to excel sheet. Thanks in advance, Ric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro creation | Excel Worksheet Functions | |||
Macro creation | Excel Worksheet Functions | |||
Macro Creation | Excel Discussion (Misc queries) | |||
Macro Creation | Excel Programming | |||
XML creation via a macro | Excel Programming |