| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute reference in VBA
Hi, I have the following problem in excel: I want to write code in VBA to clear the contents for rows J13:J224. The only problem is that, when I insert a row in this range, cell J224 becomes cell J225. Is it possible in VBA to make an absolute reference to cell J224? It should be possible to insert multiple rows in the range (J13:J224). Thanks in advance! -- leonidas ------------------------------------------------------------------------ leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375 View this thread: http://www.excelforum.com/showthread...hreadid=553151 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Absolute cell reference will not remain absolute. | Excel Worksheet Functions | |||
| How can I do an Absolute Cell Reference but non Absolute Cell Pais | Excel Programming | |||
| How can I do an Absolute Cell Reference but non Absolute Cell Pais | Excel Programming | |||
| absolute reference | Excel Discussion (Misc queries) | |||
| Absolute Reference | Excel Worksheet Functions | |||
![leonidas[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
