Posted to microsoft.public.excel.programming

mushy_peas[_9_] mushy_peas[_9_] is offline

external usenet poster

Posts: 1

Ignore formulas

i have this line which finds the next available cell in a certain
colum.
ActiveSheet.Range("b60000").End(xlUp).Offset(1, 0).Select

is there a way to get it to ignore formulas too.

Cheers in advance.

---
Message posted from http://www.ExcelForum.com/

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
macro ignore formulas	puiuluipui	Excel Discussion (Misc queries)	3	October 19th 09 09:54 PM
getting formulas to ignore text	Reggie1000	Excel Discussion (Misc queries)	2	May 23rd 09 12:28 PM
ignore formulas in dynamic range	skippy51	Excel Discussion (Misc queries)	1	January 2nd 09 05:01 PM
how do i get excel to ignore a value when using formulas	andy in leeds	Excel Discussion (Misc queries)	4	August 26th 06 12:12 PM
how do you ignore blank cells in formulas	Kerry	Excel Discussion (Misc queries)	2	February 16th 05 01:56 PM

All times are GMT +1. The time now is 08:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us