NEWB to Macros

charlesdh · #18 06-17-2014, 12:48 PM

Hi,

My 2 cents again. Hope I'm not interfering too much.
You mentioned

Quote:

Where you asked that I perform the End Down function while in K1, and asked what row I was in- it shot me to the last possible row (1,048,576). Not sure if that was what it was supposed to do or not! But my answer is 1,048,576!

I think the reason is if in the range you specified there in no data the code will take you to the "Last" row in that column. If however, you have date in row 20 you will then see that as the "Last" row.

Added: I too learned the "Old Fashion" way. Trial and error.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formatting contents after Tab of continuous lines or formatting specific area of word	pawii	Word	1	05-12-2014 05:24 AM
macros	stebrownsword	Word VBA	0	08-28-2013 01:16 AM
How to do Formatting Using Macros	anju16saini	Word VBA	1	03-11-2013 04:15 AM
Formatting with macros	WaltR	Word VBA	8	05-15-2012 06:28 PM
Macros	nore	Outlook	0	06-01-2011 04:39 PM