| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace "A2" with Active cell
Good day everyone,
Would someone be kind enough to let me know how I could replace "A2" by the active cell in the following formula: With ActiveSheet .Cells(1, 1).End(xlDown).Offset(1).Select .Range("A2", .Cells(UBound(Arr, 1), UBound(Arr, 2))).Value = Arr End With Thank you for your time Denys |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| how do I change color of "active" cell to differentiate from rest | Excel Discussion (Misc queries) | |||
| Replace(ActiveCell.Formula, "Round(","") not working as expected | Excel Programming | |||
| Replace dialog should put focus on "Find What" not "Replace With" | Excel Discussion (Misc queries) | |||
![Denys[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
