| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Find empty cell then insert range in active row
Need help please!
Below is my current code that I believe can be more efficiently executed. I have the times in Range ("F50:I50") that I would like inserted into the next blank row in the range (F9:I16). Thanks for your help. Range("f9:f16").Find("").Activate ActiveCell.Value = "8:00 AM": ActiveCell.Offset(0, 1).Activate ActiveCell.Value = "12:00 PM": ActiveCell.Offset(0, 1).Activate ActiveCell.Value = "1:00 PM": ActiveCell.Offset(0, 1).Activate ActiveCell.Value = "5:00 PM" |
|
#2
|
|||
|
|||
|
Quote:
Found a faster approach but still wanting to speed up the macro. Here's my current code: Range("F9:F16").Find("").Activate Range("F50:I50").Copy: ActiveCell.PasteSpecial Paste:=xlPasteValues |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert selected cell value into next cell in range that is empty | Excel Worksheet Functions | |||
| How do i find last not empty cell in a range | Excel Worksheet Functions | |||
| find row number of next empty cell in range | Excel Programming | |||
| Find first empty cell in range and paste formula?? | Excel Programming | |||
| find range name for active cell | Excel Programming | |||
Hybrid Mode
