Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro that will paste a number in first blank cell of a column
I would like to create a formula or macro that will take a number that always
comes from the same cell but then pastes that information in the first blank cell within a column. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro that will paste a number in first blank cell of a column
Select the cell you want to copy and run this macro:
Sub PlaceIt() Set r = Selection v = r.Value For Each cell In Range("F:F") If cell.Value = "" Then cell.Value = v Exit Sub End If Next End Sub The code uses column F, but you can change it. If you click on a cell, say B9, and run the macro, then value in B9 will be pasted to the first cell in column F that is blank. -- Gary''s Student - gsnu200909 "asebes" wrote: I would like to create a formula or macro that will take a number that always comes from the same cell but then pastes that information in the first blank cell within a column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need macro to move to first blank cell in column | Excel Discussion (Misc queries) | |||
macro to delete rows if cell blank in column | Excel Discussion (Misc queries) | |||
Macro to go to next blank cell in column | Excel Discussion (Misc queries) | |||
Macro copy and paste = blank worksheet | Excel Discussion (Misc queries) | |||
Using a Macro to paste into Blank Cells | Excel Worksheet Functions |