hi
To all you excel gods
how to make workbook if inactive for eg (30sec) make last empty cell in column b the active cell would much appreciate any help and time with this subject
cheer
shane
hi
To all you excel gods
how to make workbook if inactive for eg (30sec) make last empty cell in column b the active cell would much appreciate any help and time with this subject
cheer
shane
hi all i have manage to find a little code but im not sure how to make it call the last emtpy cell in column b
Please Login or Register to view this content.
Hi ssperyer,
In ThisWorkbook module, place this code :
In an other module, place this code :Please Login or Register to view this content.
Change the sheet as per your workbook.Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
hi thanks alot for your GC excel
help you legend!!
there only one little problem it goes the last filled cell in column b not the next empty cell in column b
cheers
shane
Small change :
Please Login or Register to view this content.
GC EXCEL THANK YOU LEGEND!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! WORKS PERFECTLY!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks