Auto Adjust cell# in a Macro

Dodge_Caravan2323 Dodge_Caravan2323 is offline

New Member

Join Date: Apr 2010

Posts: 1

6th Apr 2010

Hey,

Does anyone know how to make a Macro auto adjust the cell #. For example if the macro needs to look at cell H8, but i insert a row, H8 becomes H9 now, but the macro is still looking in cell H8. Is there a way to make the macro automatically look at H9 without having to retype H9 as i have many to retype?

Thanks a lot!!!

« select a specific ActiveCell by VBA | Table Name »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cell width auto adjust	KB	Microsoft Excel Misc	0	26th Dec 2008 08:21 PM
Can I create a macro to adjust the height of the cell according t.	=?Utf-8?B?VGRhdmlz?=	Microsoft Excel Programming	1	5th Nov 2007 02:58 AM
Auto-adjust cell height to accommodate contained text.	=?Utf-8?B?UEVUQmVya2VsZXk=?=	Microsoft Excel Misc	5	28th Oct 2005 05:50 PM
cell to auto adjust to fit text in excel 02	=?Utf-8?B?S2VpdGg=?=	Microsoft Excel Misc	0	12th May 2005 04:04 AM
Auto execute a macro if a cell value=1 ?	Sven	Microsoft Excel Programming	3	16th May 2004 12:06 AM