Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro:- Find first blank cell and write text
Hi All,
I have a spreadsheet in 9 Columns (A to I) and, at the moment, 772 Rows. I want to write a macro that:- Finds the first blank cell in column B, (ie B772) Writes some text into that cell, Steps to the next cell on the right, (ie C772) Writes some text into that cell, Steps to the next cell on the right, (ie D772) Writes some text into that cell, Steps across 2 cells to the right, (ie F772) Writes some text into that cell, Steps across 3 cells to the right and 1 down, (ie I773) Writes some text into that cell. End the macro. The text being written to the cells will be the same on all occasions. Can anyone help pleaese, many thanks. -- Mac Macdonald |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to write a macro that will clear validated cells to blank? | Excel Worksheet Functions | |||
how do I write a macro to show the find dialog box in excel 2003 | Excel Discussion (Misc queries) | |||
macro to find the last blank cell in col. A | Excel Discussion (Misc queries) | |||
how do I write macro to sum numbers up to next blank line? | Excel Discussion (Misc queries) | |||
Find a non-blank cell and bring back text a in same row | Excel Worksheet Functions |