Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select next blank cell in column, before running macro
Keeping in mind, Im a rookie...
Hello All, I have a spreadsheet that tracks how many estimates our department does with other pertinent data The macro I recorded opens a text file formats it with text to column and then copies specific cells and pastes them to one row (11 consecutive cells) Is there a way to have the macro select the next blank cell in column "A" before starting executing the rest of the macro? Thnx, BadRasta |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select next blank cell in column, before running macro
The best time to learn procedure is now. ALWAYS post your code for comments.
-- Don Guillett Microsoft MVP Excel SalesAid Software "BadRasta" wrote in message ... Keeping in mind, Im a rookie... Hello All, I have a spreadsheet that tracks how many estimates our department does with other pertinent data The macro I recorded opens a text file formats it with text to column and then copies specific cells and pastes them to one row (11 consecutive cells) Is there a way to have the macro select the next blank cell in column "A" before starting executing the rest of the macro? Thnx, BadRasta |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select next blank cell in column, before running macro
add
range("A1").end(xldown).offset(1).select to just before the paste section. it would be easier to say where if you showed your code. "BadRasta" wrote in message ... Keeping in mind, Im a rookie... Hello All, I have a spreadsheet that tracks how many estimates our department does with other pertinent data The macro I recorded opens a text file formats it with text to column and then copies specific cells and pastes them to one row (11 consecutive cells) Is there a way to have the macro select the next blank cell in column "A" before starting executing the rest of the macro? Thnx, BadRasta |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to check if cell is blank before running macro | Excel Programming | |||
Select Cell in first blank column of a row | Excel Programming | |||
Select all cells in a column up to a blank cell | Excel Programming | |||
I want to select the first blank cell in column A | Excel Worksheet Functions | |||
Can't select another cell after running a macro.... | Excel Programming |