Thread
:
Simple Macro... i guess
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Simple Macro... i guess
cells(rows.count,"c").end(xlup).select
but selections are usually NOT necessary OR desirable.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Vincent" wrote in message
...
Hi everyone,
I´m a noob at VBA, so sorry if i offend anyone:)
I want a macro that goes to the last written cell of a column.
I tried:
Sub Macro 1
Max(Range("C:C")).Select
End Sub
Wich obviously didn´t work. In column C i had to insert the function
IF(B="";"";row()) in order to have the maximum value matching the last
written cell in column B.
I wanted that macro to send me to the maximum value of column C :)
Best Regards
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett