Bls: ]] XL-mania [[ Kursor ke sell yang ada isi terakhir

 

dapat menggunakan macro dengan properti end.

Range(reference).end(Direction).select

Direction dapat berupa xlUp, xlDown, xlRight, atau xlDown

range tidak teratur seperti apa ya..??

regards,

Hachi

---

Dari: "harry.salim@gmail.com" <harry.salim@gmail.com>
Kepada: XL-mania <XL-mania@yahoogroups.com>
Dikirim: Jumat, 27 Mei 2011 15:24
Judul: ]] XL-mania [[ Kursor ke sell yang ada isi terakhir

Dear pakar XL,


Saya ingin tanya ada tombol khusus atau rumus yg mengarah kursor ke cell terakhir yang ada nilai tp cell terakhir dengan column dan row yg range cell tidak teratur qtynya yg ada isi?
Selanjutnya bagaimana cara menggunakan autosum dr column dan row range cellnya tidak teratur.

Thanks
Harry 
Sent from my BlackBerry® smartphone from Sinyal Bagus XL, Nyambung Teruuusss...!

------------------------------------

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| maaf baru moderate sekarang... momods kurang tidur berhari-hari  |
| jadi budak kantoooOOooorrr...                                    |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/          |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html          |
+-------------------------------------------------------------------+
| Message lama ada di :                                            |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/XL-mania/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/XL-mania/join
    (Yahoo! ID required)

<*> To change settings via email:
    XL-mania-digest@yahoogroups.com
    XL-mania-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    XL-mania-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 67

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| maaf baru moderate sekarang... momods kurang tidur berhari-hari   |
| jadi budak kantoooOOooorrr...                                     |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___