Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a Whole User Defined Row Using VBA
Afternoon all, How is it possible to get VBA to select a user defined row (Defined in Insert - Name - Define) Copy the row and insert the copied cells below.... Its for a huge report I'm working on... It's prooving to be quite a dilemer and i cant crack it, if you need an example or any further data then happy to provide... Please HELP! Thanks in advance Mike -- Mikey2005 ------------------------------------------------------------------------ Mikey2005's Profile: http://www.excelforum.com/member.php...o&userid=31316 View this thread: http://www.excelforum.com/showthread...hreadid=510015 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a Whole User Defined Row Using VBA
Thanks... I cant quite get this to work because im adding it to script i already have and cant quite tie it together... Whole cenario is i have a tab with 2 rows of data on... one on row *10* and one on row *20* for instance. I need these data sources to grow.... so the macro will copy row *10*, insert and paste the data below in a new row. Same for row *20*, the problem occurs when on running it a second time it copys row *20* again, when because of the insert above by row 10 it effectivly needs to look for row *21* copy insert and paste....??? Thanks Again... -- Mikey2005 ------------------------------------------------------------------------ Mikey2005's Profile: http://www.excelforum.com/member.php...o&userid=31316 View this thread: http://www.excelforum.com/showthread...hreadid=510015 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Defined formula, selecting range | Excel Programming | |||
"User-defined type not defined" message in Excel | Excel Discussion (Misc queries) | |||
Workspace faux user-defined type not defined | Excel Programming | |||
User-defined data type; Error: Only User-defined types... | Excel Programming | |||
Word.Document - user defined type not defined | Excel Programming |