Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ignore formulas
No, if the cell isn't empty, it will go to that cell.
You might be able to achieve what you want using specialcells, but it sounds like you want to find the next available cell with available meaning it appears empty although it may contain a formula returning a null string or it may actually be empty. I think to resolve that, you would need to loop through the possibilities and see which appear to be blank. -- Regards, Tom Ogilvy "mushy_peas " wrote in message ... 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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ignore formulas
Cheers Tom Ogilvy.
Back to the drawing board for me then. THank -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro ignore formulas | Excel Discussion (Misc queries) | |||
getting formulas to ignore text | Excel Discussion (Misc queries) | |||
ignore formulas in dynamic range | Excel Discussion (Misc queries) | |||
how do i get excel to ignore a value when using formulas | Excel Discussion (Misc queries) | |||
how do you ignore blank cells in formulas | Excel Discussion (Misc queries) |