Thread
:
HOW TO SELECT NEXT CELL OF LAST VALUE CELL
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
HOW TO SELECT NEXT CELL OF LAST VALUE CELL
try
cells(10,cells(columns.count,10).end(xltoleft).col umn+1).select
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"K" wrote in message
...
Hi, in macro how you can select the next cell of the last value cell
in coloumn
For example If I have value in cell A1 to A10 then how can I select
next cell
of cell A10 which will be B10.
Please if anybody can help
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett