Re: [belajar-excel] merapatkan data / mengisi baris yang masih kosong
Coba dengan code ini, (saya lupa siapa pemilik code ini, cuma ini sering saya pake ) Sub Sel_kosong_sm_dg_atasnya() Dim Cell As Range For Each Cell In Selection If Cell = Then Cell.FormulaR1C1 = =R[-1]C End If Next End Sub cara pake : Blok B2:B35 kemudian jalankan code nya dengan cara tekan ALT + F8 Terima kasih. On 01/04/2015 12:29 PM, Liem Suliem liemsul...@yahoo.co.id [belajar-excel] wrote: dh salam be excel.. saya punya data tarikan dari program yang datanya tidak rapat.. maksud saya akan saya butkan kolom bantu agar data tersebut terisi di setiap baris untuk jelasnya file terlampir... salam liem
Bls: [belajar-excel] merapatkan data / mengisi baris yang masih kosong
pak hk.. belum terisi semua pak...pak dede makasih pak berhasil.. Pada Rabu, 1 April 2015 13:47, Dede pmaho_l...@nabatisnack.co.id [belajar-excel] belajar-excel@yahoogroups.com menulis: Adalgai cara yang lain Mr Liem, Letakkanformula ini di cell c2 =IF(LEN(B2)1;B2;C1) Salam DD From: hendrik karnadihendrikkarn...@yahoo.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com] Sent: 01 April 2015 13:44 To: belajar-excel@yahoogroups.com Subject: Re: [belajar-excel] merapatkan data / mengisi baris yang masihkosong Hai Liem, Coba2 begini Sorot sel B2 s/d B35 Tekan F5, pilih special, blank Kmd pada formula bar ketik =B2 Lalu tekan Ctrl dan Enter bersamaan... Salam, HK From:Liem Suliem liemsul...@yahoo.co.id [belajar-excel]belajar-excel@yahoogroups.com To: belajar-excel@yahoogroups.com Sent: Wednesday, 1 April 2015, 12:29 Subject: [belajar-excel] merapatkandata / mengisi baris yang masih kosong [1 Attachment] dh salam be excel.. saya punya data tarikan dari program yang datanya tidak rapat.. maksud saya akan saya butkan kolom bantu agar data tersebut terisidi setiap baris untuk jelasnya file terlampir... salam liem This e-mail and any files transmitted with it are confidential andintended solely for the use of the individual to whom it is addressed. If youhave received this email in error please send it back to the person that sentit to you. Any views or opinions presented are solely those of its author anddo not necessarily represent those of NABATI or any of its subsidiarycompanies. Unauthorized publication, use, dissemination, forwarding, printingor copying of this email and its associated attachments is strictly prohibited. #yiv3310391543 -- #yiv3310391543ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3310391543 #yiv3310391543ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3310391543 #yiv3310391543ygrp-mkp #yiv3310391543hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3310391543 #yiv3310391543ygrp-mkp #yiv3310391543ads {margin-bottom:10px;}#yiv3310391543 #yiv3310391543ygrp-mkp .yiv3310391543ad {padding:0 0;}#yiv3310391543 #yiv3310391543ygrp-mkp .yiv3310391543ad p {margin:0;}#yiv3310391543 #yiv3310391543ygrp-mkp .yiv3310391543ad a {color:#ff;text-decoration:none;}#yiv3310391543 #yiv3310391543ygrp-sponsor #yiv3310391543ygrp-lc {font-family:Arial;}#yiv3310391543 #yiv3310391543ygrp-sponsor #yiv3310391543ygrp-lc #yiv3310391543hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3310391543 #yiv3310391543ygrp-sponsor #yiv3310391543ygrp-lc .yiv3310391543ad {margin-bottom:10px;padding:0 0;}#yiv3310391543 #yiv3310391543actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3310391543 #yiv3310391543activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3310391543 #yiv3310391543activity span {font-weight:700;}#yiv3310391543 #yiv3310391543activity span:first-child {text-transform:uppercase;}#yiv3310391543 #yiv3310391543activity span a {color:#5085b6;text-decoration:none;}#yiv3310391543 #yiv3310391543activity span span {color:#ff7900;}#yiv3310391543 #yiv3310391543activity span .yiv3310391543underline {text-decoration:underline;}#yiv3310391543 .yiv3310391543attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3310391543 .yiv3310391543attach div a {text-decoration:none;}#yiv3310391543 .yiv3310391543attach img {border:none;padding-right:5px;}#yiv3310391543 .yiv3310391543attach label {display:block;margin-bottom:5px;}#yiv3310391543 .yiv3310391543attach label a {text-decoration:none;}#yiv3310391543 blockquote {margin:0 0 0 4px;}#yiv3310391543 .yiv3310391543bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3310391543 .yiv3310391543bold a {text-decoration:none;}#yiv3310391543 dd.yiv3310391543last p a {font-family:Verdana;font-weight:700;}#yiv3310391543 dd.yiv3310391543last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3310391543 dd.yiv3310391543last p span.yiv3310391543yshortcuts {margin-right:0;}#yiv3310391543 div.yiv3310391543attach-table div div a {text-decoration:none;}#yiv3310391543 div.yiv3310391543attach-table {width:400px;}#yiv3310391543 div.yiv3310391543file-title a, #yiv3310391543 div.yiv3310391543file-title a:active, #yiv3310391543 div.yiv3310391543file-title a:hover, #yiv3310391543 div.yiv3310391543file-title a:visited {text-decoration:none;}#yiv3310391543 div.yiv3310391543photo-title a, #yiv3310391543 div.yiv3310391543photo-title a:active, #yiv3310391543 div.yiv3310391543photo-title a:hover, #yiv3310391543 div.yiv3310391543photo-title a:visited {text-decoration:none;}#yiv3310391543 div#yiv3310391543ygrp-mlmsg #yiv3310391543ygrp-msg p a span.yiv3310391543yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3310391543 .yiv3310391543green
[belajar-excel] merapatkan data / mengisi baris yang masih kosong [1 Attachment]
dhsalam be excel..saya punya data tarikan dari program yang datanya tidak rapat..maksud saya akan saya butkan kolom bantu agar data tersebut terisi di setiap baris untuk jelasnya file terlampir... salamliem rapatkan data.xlsx Description: MS-Excel 2007 spreadsheet
Re: Bls: [belajar-excel] merapatkan data / mengisi baris yang masih kosong
Sdh tekan Ctrl Enter pak ? Salam,HK From: Liem Suliem liemsul...@yahoo.co.id [belajar-excel] belajar-excel@yahoogroups.com To: belajar-excel@yahoogroups.com Sent: Wednesday, 1 April 2015, 14:20 Subject: Bls: [belajar-excel] merapatkan data / mengisi baris yang masih kosong pak hk.. belum terisi semua pak...pak dede makasih pak berhasil.. Pada Rabu, 1 April 2015 13:47, Dede pmaho_l...@nabatisnack.co.id [belajar-excel] belajar-excel@yahoogroups.com menulis: Adalgai cara yang lain Mr Liem, Letakkanformula ini di cell c2 =IF(LEN(B2)1;B2;C1) Salam DD From: hendrik karnadihendrikkarn...@yahoo.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com] Sent: 01 April 2015 13:44 To: belajar-excel@yahoogroups.com Subject: Re: [belajar-excel] merapatkan data / mengisi baris yang masihkosong Hai Liem, Coba2 begini Sorot sel B2 s/d B35 Tekan F5, pilih special, blank Kmd pada formula bar ketik =B2 Lalu tekan Ctrl dan Enter bersamaan... Salam, HK From:Liem Suliem liemsul...@yahoo.co.id [belajar-excel]belajar-excel@yahoogroups.com To: belajar-excel@yahoogroups.com Sent: Wednesday, 1 April 2015, 12:29 Subject: [belajar-excel] merapatkandata / mengisi baris yang masih kosong [1 Attachment] dh salam be excel.. saya punya data tarikan dari program yang datanya tidak rapat.. maksud saya akan saya butkan kolom bantu agar data tersebut terisidi setiap baris untuk jelasnya file terlampir... salam liem This e-mail and any files transmitted with it are confidential andintended solely for the use of the individual to whom it is addressed. If youhave received this email in error please send it back to the person that sentit to you. Any views or opinions presented are solely those of its author anddo not necessarily represent those of NABATI or any of its subsidiarycompanies. Unauthorized publication, use, dissemination, forwarding, printingor copying of this email and its associated attachments is strictly prohibited. #yiv0498113881 #yiv0498113881 -- #yiv0498113881ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0498113881 #yiv0498113881ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0498113881 #yiv0498113881ygrp-mkp #yiv0498113881hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0498113881 #yiv0498113881ygrp-mkp #yiv0498113881ads {margin-bottom:10px;}#yiv0498113881 #yiv0498113881ygrp-mkp .yiv0498113881ad {padding:0 0;}#yiv0498113881 #yiv0498113881ygrp-mkp .yiv0498113881ad p {margin:0;}#yiv0498113881 #yiv0498113881ygrp-mkp .yiv0498113881ad a {color:#ff;text-decoration:none;}#yiv0498113881 #yiv0498113881ygrp-sponsor #yiv0498113881ygrp-lc {font-family:Arial;}#yiv0498113881 #yiv0498113881ygrp-sponsor #yiv0498113881ygrp-lc #yiv0498113881hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0498113881 #yiv0498113881ygrp-sponsor #yiv0498113881ygrp-lc .yiv0498113881ad {margin-bottom:10px;padding:0 0;}#yiv0498113881 #yiv0498113881actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0498113881 #yiv0498113881activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0498113881 #yiv0498113881activity span {font-weight:700;}#yiv0498113881 #yiv0498113881activity span:first-child {text-transform:uppercase;}#yiv0498113881 #yiv0498113881activity span a {color:#5085b6;text-decoration:none;}#yiv0498113881 #yiv0498113881activity span span {color:#ff7900;}#yiv0498113881 #yiv0498113881activity span .yiv0498113881underline {text-decoration:underline;}#yiv0498113881 .yiv0498113881attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0498113881 .yiv0498113881attach div a {text-decoration:none;}#yiv0498113881 .yiv0498113881attach img {border:none;padding-right:5px;}#yiv0498113881 .yiv0498113881attach label {display:block;margin-bottom:5px;}#yiv0498113881 .yiv0498113881attach label a {text-decoration:none;}#yiv0498113881 blockquote {margin:0 0 0 4px;}#yiv0498113881 .yiv0498113881bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0498113881 .yiv0498113881bold a {text-decoration:none;}#yiv0498113881 dd.yiv0498113881last p a {font-family:Verdana;font-weight:700;}#yiv0498113881 dd.yiv0498113881last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0498113881 dd.yiv0498113881last p span.yiv0498113881yshortcuts {margin-right:0;}#yiv0498113881 div.yiv0498113881attach-table div div a {text-decoration:none;}#yiv0498113881 div.yiv0498113881attach-table {width:400px;}#yiv0498113881 div.yiv0498113881file-title a, #yiv0498113881 div.yiv0498113881file-title a:active, #yiv0498113881 div.yiv0498113881file-title a:hover, #yiv0498113881 div.yiv0498113881file-title a:visited {text-decoration:none;}#yiv0498113881 div.yiv0498113881photo-title a, #yiv0498113881 div.yiv0498113881photo-title a:active, #yiv0498113881
RE: [belajar-excel] merapatkan data / mengisi baris yang masih kosong
Adal gai cara yang lain Mr Liem, Letakkan formula ini di cell c2 =IF(LEN(B2)1;B2;C1) Salam DD From: hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com] Sent: 01 April 2015 13:44 To: belajar-excel@yahoogroups.com Subject: Re: [belajar-excel] merapatkan data / mengisi baris yang masih kosong Hai Liem, Coba2 begini Sorot sel B2 s/d B35 Tekan F5, pilih special, blank Kmd pada formula bar ketik =B2 Lalu tekan Ctrl dan Enter bersamaan... Salam, HK _ From: Liem Suliem liemsul...@yahoo.co.id [belajar-excel] belajar-excel@yahoogroups.com To: belajar-excel@yahoogroups.com Sent: Wednesday, 1 April 2015, 12:29 Subject: [belajar-excel] merapatkan data / mengisi baris yang masih kosong [1 Attachment] dh salam be excel.. saya punya data tarikan dari program yang datanya tidak rapat.. maksud saya akan saya butkan kolom bantu agar data tersebut terisi di setiap baris untuk jelasnya file terlampir... salam liem _ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
Re: [belajar-excel] merapatkan data / mengisi baris yang masih kosong
Hai Liem,Coba2 beginiSorot sel B2 s/d B35Tekan F5, pilih special, blankKmd pada formula bar ketik =B2Lalu tekan Ctrl dan Enter bersamaan... Salam,HK From: Liem Suliem liemsul...@yahoo.co.id [belajar-excel] belajar-excel@yahoogroups.com To: belajar-excel@yahoogroups.com Sent: Wednesday, 1 April 2015, 12:29 Subject: [belajar-excel] merapatkan data / mengisi baris yang masih kosong [1 Attachment] dhsalam be excel..saya punya data tarikan dari program yang datanya tidak rapat..maksud saya akan saya butkan kolom bantu agar data tersebut terisi di setiap baris untuk jelasnya file terlampir... salamliem #yiv9518535571 #yiv9518535571 -- #yiv9518535571ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9518535571 #yiv9518535571ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9518535571 #yiv9518535571ygrp-mkp #yiv9518535571hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9518535571 #yiv9518535571ygrp-mkp #yiv9518535571ads {margin-bottom:10px;}#yiv9518535571 #yiv9518535571ygrp-mkp .yiv9518535571ad {padding:0 0;}#yiv9518535571 #yiv9518535571ygrp-mkp .yiv9518535571ad p {margin:0;}#yiv9518535571 #yiv9518535571ygrp-mkp .yiv9518535571ad a {color:#ff;text-decoration:none;}#yiv9518535571 #yiv9518535571ygrp-sponsor #yiv9518535571ygrp-lc {font-family:Arial;}#yiv9518535571 #yiv9518535571ygrp-sponsor #yiv9518535571ygrp-lc #yiv9518535571hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9518535571 #yiv9518535571ygrp-sponsor #yiv9518535571ygrp-lc .yiv9518535571ad {margin-bottom:10px;padding:0 0;}#yiv9518535571 #yiv9518535571actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9518535571 #yiv9518535571activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9518535571 #yiv9518535571activity span {font-weight:700;}#yiv9518535571 #yiv9518535571activity span:first-child {text-transform:uppercase;}#yiv9518535571 #yiv9518535571activity span a {color:#5085b6;text-decoration:none;}#yiv9518535571 #yiv9518535571activity span span {color:#ff7900;}#yiv9518535571 #yiv9518535571activity span .yiv9518535571underline {text-decoration:underline;}#yiv9518535571 .yiv9518535571attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9518535571 .yiv9518535571attach div a {text-decoration:none;}#yiv9518535571 .yiv9518535571attach img {border:none;padding-right:5px;}#yiv9518535571 .yiv9518535571attach label {display:block;margin-bottom:5px;}#yiv9518535571 .yiv9518535571attach label a {text-decoration:none;}#yiv9518535571 blockquote {margin:0 0 0 4px;}#yiv9518535571 .yiv9518535571bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9518535571 .yiv9518535571bold a {text-decoration:none;}#yiv9518535571 dd.yiv9518535571last p a {font-family:Verdana;font-weight:700;}#yiv9518535571 dd.yiv9518535571last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9518535571 dd.yiv9518535571last p span.yiv9518535571yshortcuts {margin-right:0;}#yiv9518535571 div.yiv9518535571attach-table div div a {text-decoration:none;}#yiv9518535571 div.yiv9518535571attach-table {width:400px;}#yiv9518535571 div.yiv9518535571file-title a, #yiv9518535571 div.yiv9518535571file-title a:active, #yiv9518535571 div.yiv9518535571file-title a:hover, #yiv9518535571 div.yiv9518535571file-title a:visited {text-decoration:none;}#yiv9518535571 div.yiv9518535571photo-title a, #yiv9518535571 div.yiv9518535571photo-title a:active, #yiv9518535571 div.yiv9518535571photo-title a:hover, #yiv9518535571 div.yiv9518535571photo-title a:visited {text-decoration:none;}#yiv9518535571 div#yiv9518535571ygrp-mlmsg #yiv9518535571ygrp-msg p a span.yiv9518535571yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9518535571 .yiv9518535571green {color:#628c2a;}#yiv9518535571 .yiv9518535571MsoNormal {margin:0 0 0 0;}#yiv9518535571 o {font-size:0;}#yiv9518535571 #yiv9518535571photos div {float:left;width:72px;}#yiv9518535571 #yiv9518535571photos div div {border:1px solid #66;height:62px;overflow:hidden;width:62px;}#yiv9518535571 #yiv9518535571photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9518535571 #yiv9518535571reco-category {font-size:77%;}#yiv9518535571 #yiv9518535571reco-desc {font-size:77%;}#yiv9518535571 .yiv9518535571replbq {margin:4px;}#yiv9518535571 #yiv9518535571ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9518535571 #yiv9518535571ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9518535571 #yiv9518535571ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9518535571 #yiv9518535571ygrp-mlmsg select, #yiv9518535571 input, #yiv9518535571 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9518535571 #yiv9518535571ygrp-mlmsg pre, #yiv9518535571 code {font:115
Bls: Bls: [belajar-excel] merapatkan data / mengisi baris yang masih kosong
maaf pak hk kurang cermat baca petunjuknya.. yang saya tekan kemarin ctrl+alt+enter.. heheheetak coba cara dari pak hk ternyata berhasil dan cara kerjanya mirip makro dari pak yanto...terimakasih atas solusinya salamliem Pada Rabu, 1 April 2015 14:44, hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel] belajar-excel@yahoogroups.com menulis: Sdh tekan Ctrl Enter pak ? Salam,HK From: Liem Suliem liemsul...@yahoo.co.id [belajar-excel] belajar-excel@yahoogroups.com To: belajar-excel@yahoogroups.com Sent: Wednesday, 1 April 2015, 14:20 Subject: Bls: [belajar-excel] merapatkan data / mengisi baris yang masih kosong pak hk.. belum terisi semua pak...pak dede makasih pak berhasil.. Pada Rabu, 1 April 2015 13:47, Dede pmaho_l...@nabatisnack.co.id [belajar-excel] belajar-excel@yahoogroups.com menulis: Adalgai cara yang lain Mr Liem, Letakkanformula ini di cell c2 =IF(LEN(B2)1;B2;C1) Salam DD From: hendrik karnadihendrikkarn...@yahoo.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com] Sent: 01 April 2015 13:44 To: belajar-excel@yahoogroups.com Subject: Re: [belajar-excel] merapatkan data / mengisi baris yang masihkosong Hai Liem, Coba2 begini Sorot sel B2 s/d B35 Tekan F5, pilih special, blank Kmd pada formula bar ketik =B2 Lalu tekan Ctrl dan Enter bersamaan... Salam, HK From:Liem Suliem liemsul...@yahoo.co.id [belajar-excel]belajar-excel@yahoogroups.com To: belajar-excel@yahoogroups.com Sent: Wednesday, 1 April 2015, 12:29 Subject: [belajar-excel] merapatkandata / mengisi baris yang masih kosong [1 Attachment] dh salam be excel.. saya punya data tarikan dari program yang datanya tidak rapat.. maksud saya akan saya butkan kolom bantu agar data tersebut terisidi setiap baris untuk jelasnya file terlampir... salam liem This e-mail and any files transmitted with it are confidential andintended solely for the use of the individual to whom it is addressed. If youhave received this email in error please send it back to the person that sentit to you. Any views or opinions presented are solely those of its author anddo not necessarily represent those of NABATI or any of its subsidiarycompanies. Unauthorized publication, use, dissemination, forwarding, printingor copying of this email and its associated attachments is strictly prohibited. #yiv2945590094 #yiv2945590094 -- #yiv2945590094ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2945590094 #yiv2945590094ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2945590094 #yiv2945590094ygrp-mkp #yiv2945590094hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2945590094 #yiv2945590094ygrp-mkp #yiv2945590094ads {margin-bottom:10px;}#yiv2945590094 #yiv2945590094ygrp-mkp .yiv2945590094ad {padding:0 0;}#yiv2945590094 #yiv2945590094ygrp-mkp .yiv2945590094ad p {margin:0;}#yiv2945590094 #yiv2945590094ygrp-mkp .yiv2945590094ad a {color:#ff;text-decoration:none;}#yiv2945590094 #yiv2945590094ygrp-sponsor #yiv2945590094ygrp-lc {font-family:Arial;}#yiv2945590094 #yiv2945590094ygrp-sponsor #yiv2945590094ygrp-lc #yiv2945590094hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2945590094 #yiv2945590094ygrp-sponsor #yiv2945590094ygrp-lc .yiv2945590094ad {margin-bottom:10px;padding:0 0;}#yiv2945590094 #yiv2945590094actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2945590094 #yiv2945590094activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2945590094 #yiv2945590094activity span {font-weight:700;}#yiv2945590094 #yiv2945590094activity span:first-child {text-transform:uppercase;}#yiv2945590094 #yiv2945590094activity span a {color:#5085b6;text-decoration:none;}#yiv2945590094 #yiv2945590094activity span span {color:#ff7900;}#yiv2945590094 #yiv2945590094activity span .yiv2945590094underline {text-decoration:underline;}#yiv2945590094 .yiv2945590094attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2945590094 .yiv2945590094attach div a {text-decoration:none;}#yiv2945590094 .yiv2945590094attach img {border:none;padding-right:5px;}#yiv2945590094 .yiv2945590094attach label {display:block;margin-bottom:5px;}#yiv2945590094 .yiv2945590094attach label a {text-decoration:none;}#yiv2945590094 blockquote {margin:0 0 0 4px;}#yiv2945590094 .yiv2945590094bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2945590094 .yiv2945590094bold a {text-decoration:none;}#yiv2945590094 dd.yiv2945590094last p a {font-family:Verdana;font-weight:700;}#yiv2945590094 dd.yiv2945590094last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2945590094 dd.yiv2945590094last p span.yiv2945590094yshortcuts {margin-right:0;}#yiv2945590094 div.yiv2945590094attach-table div div a {text-decoration:none;}#yiv2945590094 div.yiv2945590094attach-table