| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting cells entered by a macro
I have a macro, that selects the last row in a range of cells and inputs a
blank row just above this (as below). I want to then format the cells I input, and am having trouble writing the macro to select them Can anyone help? Dim LastRow As Long, NumberOfBlankRows NumberOfBlankRows = 1 LastRow = Range("A3:R1000").Find(What:="*", SearchOrder:=xlColumns, _ SearchDirection:=xlPrevious, LookIn:=xlValues).Row Intersect(Range("A:R"), Rows(LastRow)).Resize(NumberOfBlankRows).Insert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting according to the date the data is entered | Excel Discussion (Misc queries) | |||
| Formatting Text in cells that already have text entered | Excel Worksheet Functions | |||
| Using a Macro in Excel 2004 to move entered data from one sheet toanother and space between rows when next data is entered? | Excel Programming | |||
| Formatting a cell to show something different the entered value | Excel Discussion (Misc queries) | |||
| Running a macro if any data is entered in a range of cells | Excel Worksheet Functions | |||
Threaded Mode
