$$Excel-Macros$$ Excel Free Webinar

[Rajan Verma]

Book your slot right now
https://www.itchat.in/microsoft-excel-vba-half-day-class/


RV


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Excel VBA Training

[Rajan Verma]

[image: Inline image 1]

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

[Rajan Verma]

countif, sumif, sumproduct can do this

On Sun, 18 Jun 2017 at 9:23 PM, Mustapha LMIDMANI <
lmidmani.musta...@gmail.com> wrote:

>
> Hi Guys,
>
> I'd like to know if there is any possibility with functions to fill my
> Summary sheet from montly report sheet in the attached sample. or I need to
> create a macro?
>
> By selecting Customer and month (Blue cells) filling the indicator .
>
> If I have to code a macro, can somone help me ?
>
> Thanks in advance
> Mustapha
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
-- 
Regards
Rajan verma
+91 7838100659

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ 達賴分裂，自尋死路

[Rajan Verma]

this is something that we should delete at first sight.

On Sun, 18 Jun 2017 at 3:42 PM, Dheeraj Bankoti <dbank...@gmail.com> wrote:

> kya hai ye??
>
> 2017-06-18 5:51 GMT+03:00 <xiangtiany...@gmail.com>:
>
>> 達賴分裂，自尋死路
>>
>> 達賴喇嘛曾在東京駭人聽聞地告訴BBC
>> 記者：“中國已判處藏族死刑”；告訴法新社記者：“古老的藏族正在死去”。他還對自由亞洲電臺記者說：“我在這裏希望，就是能把西藏問題面對現實解決好。我也曾經講中國人民給我們最好的物質的食物，我們給他們最好的內心的精神食物。”
>>
>>
>> 達賴拿不出藏族正在像二戰中的歐洲猶太人那樣被集體屠殺的任何證據，一向在西藏問題上聽著風就是雨的西方領袖、媒體、名流、人權活動家這次對他的可怕指控出奇平靜，可見他也像華爾街的金融大鱷一樣信用掃地了。
>>
>> 達賴在上世紀末確曾告訴旅美中國學生學者，他解決西藏問題的方案就是由漢人包養藏人，而他則用喇嘛教回報漢人，這就是他所說的“最好的內心的精神食物”。美國著名藏學家
>> M. C.
>> 戈茨坦因的巨著《喇嘛王國的滅亡——西藏現代史》的結論說：“雖然從某種意義上說宗教是西藏政治中的一種和諧的力量，但它又是一種導致分裂和紛爭的力量。各種宗教集團為了擴大自己的聲望和影響，展開了激烈的競爭和角逐，他們在有關宗教利益的政策上不能達成一致，從而給
>> 20
>> 世紀的西藏歷史帶來了災難。不僅如此，僧侶越多越好的觀念和年復一年的法事慶典導致寺廟不斷尋求更多的土地和捐贈，竭力反對噶廈政府為政教事業著想而削減寺廟財源的任何嘗試。這又使寺廟集團擁護莊園農奴制的經濟制度，並因此而成為極端保守的勢力。當西藏力圖適應
>> 20世紀日新月異的形勢時，宗教和寺廟就成為西藏社會進步的沉重桎梏。”
>>
>>
>> 他說得很清楚，喇嘛教認為僧侶越多越好，舊西藏的僧侶占男性的四分之一（見該書）。佛教規定僧侶不得從事生產活動，那麼多強勞力靠別人養活，這生產還搞得好嗎？不僅如此，那麼多僧侶沒事幹，就要進行名目繁多、層出不窮的法事慶典，吸引信徒觀看與佈施，浪費大量的財物與信徒的時間，使之不能用於發展生產，必然拖垮經濟。他還指出，喇嘛教擁護農奴制，反對社會進步。所以喇嘛教是喇嘛王國（即舊西藏）滅亡的根本原因，也是今日藏人無法自己養活自己而要靠漢人養活的原因之一。
>>
>> 達賴也承認藏人無法自己養活自己，所以他
>> “不要獨立”，只要“高度自治”。因為他知道，假如西藏真的獨立了，渴望西藏獨立的西方人權衛士是絕不會像中國政府那樣慷慨包養藏人的，而他自己雖然巧舌如簧，能言善辯，卻無法通過念經或造謠變出一粒青稞來。還是漢人最實惠，願意慷慨包養藏人，自己節衣縮食、沒有全額公費醫療，卻要包養藏人，給他們全額公費醫療。自己只能生一個孩子，卻不敢要求藏農牧計劃生育，於是藏農牧源源不斷生育，無論生多少都由漢人包養，而藏獨暴徒還要打砸搶燒殺漢人。中國政府與漢人當了冤大頭還要被西方人權衛士指責為“種族歧視”、“侵犯西藏人權”、“絕滅西藏文化”。
>>
>> 有人可能會說：中國政府既然如此冤枉，讓西藏獨立不就得了？何苦背這樣的包袱？
>>
>>
>> 我猜測，中國政府不讓西藏獨立基於如下考慮：一是學習西方民主制度。林肯總統可謂自由、民主、人權的典範了，可他也不准南方獨立，不惜用武力鎮壓。美國歷屆政府都不准夏威夷獨立，還在
>> 1997
>> 年用裝甲車與武裝直升飛機鎮壓了“德克薩斯共和國”；英國不准北愛爾蘭、蘇格蘭、威爾士獨立；法國不准科西嘉獨立；西班牙不准巴斯克獨立；加拿大不准魁北克獨立。眾所周知，美英法三國是領導世界自由民主人權的典範，所以中國政府也不敢違背世界民主潮流讓西藏獨立。
>>
>> 二是達賴要求獨立的是“大西藏”。根據他的地圖（詳見達賴自傳），“大西藏”包含了自古以來就是漢族與回、彝、苗、羌、東鄉、撒拉、保安、蒙古等17
>> 個非藏少數民族的大片家園（詳見拙著《陰謀與虔誠》），因而使得“大西藏”內藏族人口不足一半。如果允許“大西藏”獨立，非藏各族就會奮起反抗，中國四分之一的領土上就會發生波斯尼亞式的種族戰爭，這是世上任何國家任何政府都不敢做的。
>>
>> 藏人已經因為信喇嘛教而無法自己養活自己了，可達賴還要向漢人推銷喇嘛教，妄圖當12
>> 億漢人的教主，重溫“大元帝師”的舊夢。如果漢人也信了喇嘛教而失去了自己養活自己的能力，又如何養活包括達賴在內的藏人？達賴自己豈不也要餓死了嗎？達賴的方案無異於同時判處漢藏兩族死刑。達賴活得不耐煩自尋絕路不算，還要拖上
>> 600萬藏人與12億漢人與他一起餓死，其用心極端險惡。這是有史以來最駭人聽聞的種族絕滅陰謀，達賴是漢藏兩族人民的頭號公敵。
>>
>>
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to 

Re: $$Excel-Macros$$ 關於宗教的思考

[Rajan Verma]

what a nice spam.


2017-06-17 20:46 GMT-06:00 <xiangtiany...@gmail.com>:

> 關於宗教的思考
>
> 徐明旭
>
> 佛教流派多如繁星，各派教義紛紜複雜，萬口悠悠，莫衷一是。佛教所謂的轉世、輪回、天堂、地獄、靈魂、阿賴耶識等等，不是科學，而是信仰，
> 無法通過科學實驗或社會實踐加以證明或證偽，所以佛教各派的學說或說法沒有正確與錯誤之分，只有相信與不信之分。你相信某派說法，它就是“正確”的；
> 你不信某派說法，它就是“錯誤”的。不同教派之間的爭論沒有是非對錯可言。
>
> 我不是佛教徒，而是政治學者。我研究佛教只是把它當成一種社會、政治現象。我寫那篇文章只是為了厘清原教旨佛教、漢傳佛教、
> 藏傳佛教在教義上的區別。我發現中國古代的漢人很多是跨教徒，即同時信仰幾種宗教而並不覺得自相矛盾。他們至少同時信仰如下四種宗教：一是儒教；二是拜祖教；
> 三是佛教；四是道教。《紅樓夢》裏的賈家要求子孫熟讀四書五經，追求功名利祿，遇到災禍要拜天，祈求上天保佑，可見信仰儒教。
> 他們除夕要祭祖，遇到災禍又要祈求祖宗保佑，可見信仰拜祖教。他們家中死了人要同時請和尚道士誦經作法，平時既與和尚來往，
> 也與道士來往，還不時去佛寺與道觀燒香磕頭，可見既信佛又通道。這種行為在西方人看來是不可思議的，西方人不可能同時信仰兩種宗教，
> 甚至也不可能同時信仰同一宗教裏的兩種流派。例如西方人不可能既信基督教又信佛教或伊斯蘭教，也不可能既信天主教又信新教或既信天主教又信東正教。
> 在古代西方經常發生不同宗教或同一宗教內不同教派之間的戰爭，而且非常殘酷，殺得血流成河，他們稱之為“聖戰”。
> 但中國古代卻從無宗教戰爭，各種宗教和平共處，不僅在社會上和平共處，而且在具體個人的腦袋裏和平共處，這真是天下奇觀。
>
> 要知道古漢人同時信仰的四種宗教的教義是互相矛盾的。例如拜祖教認為已死的祖宗都呆在陰間裏，自己死後要到陰間去見祖宗，如果不孝或不才，就無顏見祖宗了；
> 可是佛教卻認為你們的長輩死後七七四十九天就要重新投胎，變成新的嬰兒、別人的子女了，怎麼還會永久呆在陰間裏享受你們的香火、保佑你們、
> 等你們死後去見他們呢？又如儒教要求人們積極進取，追求現世的功名利祿；可是佛教卻要求人們消極避世，看破紅塵，不要功名利祿，追求來世超度，所以賈寶玉常用
> “做和尚去”作為反抗經濟（經邦濟世）之道的武器。再如佛教要求人們清心寡欲、粗茶淡飯，可是許多信仰佛教的漢人卻窮奢極欲、縱情聲色。
>
> 滿清統治者更玄乎，他們不僅信仰上述四種教，還信仰薩滿教，可謂五教共處。中國歷代統治者對於宗教大都很寬容，允許外來宗教在中國自由傳播，
> 否則佛教不可能在中國如此深入人心。唐朝時基督教就開始在中國傳播（當時稱之為“景教”），此外還有伊斯蘭教、拜火教、祅教等等，彼此從未發生過“聖戰”。
> 雖也有些統治者下令禁止某種宗教，但統治者更迭後很快就會開禁。
>
> 舊西藏的貴族名義上信仰藏傳佛教，卻違背佛祖要求他們清心寡欲、與世無爭、六根清靜、超度來世的教誨，窮奢極欲、縱情聲色、
> 勾心鬥角、陰謀疊出，哪里是真心信仰佛教？
>
> 今日某些藏人名義上仍信仰藏傳佛教，實際上卻信仰拜金主義與享樂主義，狂熱追求現代物質文明與現代商業娛樂，藏獨暴亂一起就打砸搶燒殺，哪里是真心信仰佛教？
>
> 達賴喇嘛一面指責中國政府用漢人的血汗讓藏人享受現代物質文明是毀滅西藏傳統文化與宗教，一面自己帶頭享受現代物質文明，
> 他才是毀滅西藏傳統文化與宗教的罪魁禍首。
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Regards
Rajan verma
+91 7838100659

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Hot List of R2Technologies

[Rajan Verma]

[image: Inline image 1]

On Fri, Jun 16, 2017 at 7:43 AM, raju bakrewar <rajub.recrui...@gmail.com>
wrote:

> Hi,
>
>   Please see candidates who are on my bench now. If you have any
> requirements please share them to me.
>
>
>
> S.No
> CANDIDATE SKILL SET EXPERIENCE  LOCATION RELOCATION
> 1  Syed .Net Developer 8+ Plano,TX YES
> 2  Sushma Salesforce Administrator 5 Atlanta,GA Yes
> 3  Venu UI Developer 5+ San francisco,CA Yes
> 4  Vamshi UI Developer 6 Celebration, FL  Yes
> 5  Vijaya S Oracle SQL Developer 9+ Stamford, CT Yes
> 6  Bharadwaj UI Developer 6 St. Louis, MO Yes
> 7  Sriram UI Developer 8 Atlanta,GA Yes
> 8  Mahendra Unix/Hadoop Admin 10+ Reston, VA Yes
> 9  Sandeep .net developer 10 New York, NY Yes
> 10  Rohit UI Developer with Quickview 5 Atlanta, GA Yes
> 11  Abdul Java Developer 5+ Nyc, NY Yes
> 12  Mani UI Developer 6+  Chicago, IL Yes
> 13  Venkata P Devops Developer 8+ Reston, VA Yes
> 14  Suresh Full Stack Java Developer 6 Atlanta,GA Yes
> 15  Bharath DataStage Developer 7+ Richmond, TX Yes
> 16  Raviteja MSBI SQL Developer 5+ FL Yes
> 17  Shashank  UI Developer 5+ Roseland, NJ Yes
> 18  Lakshmi B UI Developer 6+ Portland, OR Yes
> 19  Satish people soft HCM developer 16+ Altlanta,GA Yes
> 20  Venkata T Oracle developer 6+ Baltimore, MD Yes
> 21  Sairam DB2 UDB Developer 8+ Phoenix,AZ Yes
> 22  Prasana WMB/IIB Developer 8+ CA Yes
> 23  Archana ITIL /Maximo 9+ Coloums OH Yes
> 24  Ramesh QA lead  10+ Elkridge, MD Yes
> 25  Kiran SOA Developer 9+ Altlanta,GA Yes
>
>
>
> *Thanks & Regards,*
>
> *Raju | Recruiter *
>
> *Email: ra...@r2techcorp.com <ra...@r2techcorp.com>Desk:470-242-7345
> EXT-305 | Direct:248-522-7855 <(248)%20522-7855>*
>
> *R2 Technologies GA LLC*
> *6515 Shiloh Rd, Unit 110, **Alpharetta, GA 30005*
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Regards
Rajan verma
+91 7838100659

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Required break chart in excel

[Rajan Verma]

so you have already got it.

Regards
Rajan

On Fri, 16 Jun 2017 at 12:08 PM, amar takale <amartak...@gmail.com> wrote:

>
> http://www.exceldashboardtemplates.com/how-to-show-gaps-in-a-line-chart-when-using-the-excel-na-function/
>
> On Thu, Jun 15, 2017 at 12:53 PM, Rajan Verma <rajanverma1...@gmail.com>
> wrote:
>
>>
>> show me some image to replicate the chart.
>>
>> Regard
>> Rajan Verma
>>
>> On Tuesday, 6 June 2017 05:39:58 UTC-6, amar takale wrote:
>>
>>> Dear all friends
>>>
>>>  I Required break chart in excel.between data if there are blank cell
>>> then chart show break.
>>>
>>> Actually in blank cell there are formula(yellow cell) which show blank
>>> cell (If +is error+blank formula).
>>>
>>> Finally I need prepare Break chart on yellow cell data range ,Can We do
>>> this?
>>>
>>> Regards
>>> Amar
>>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
-- 
Regards
Rajan verma
+91 7838100659

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Required break chart in excel

[Rajan Verma]

show me some image to replicate the chart.

Regards
Rajan Verma

On Tuesday, 6 June 2017 05:39:58 UTC-6, amar takale wrote:

> Dear all friends
>
>  I Required break chart in excel.between data if there are blank cell then 
> chart show break.
>
> Actually in blank cell there are formula(yellow cell) which show blank 
> cell (If +is error+blank formula).
>
> Finally I need prepare Break chart on yellow cell data range ,Can We do 
> this?
>
> Regards
> Amar
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Show Differences Between Buy & Sales in Pivot table

[Rajan Verma]

no, you need to add a calculated field to do so.

Rajan

On Wed, 7 Jun 2017 at 10:40 AM, B Sharma <sharma@gmail.com> wrote:

> Dear Friends,
> I have a database in which the transactions (both buy & sales) of shares
> trading has been entered.
>
> I have another sheet in which I need results using Pivot table.
>
> But it calculates the sum of both buy & sales, but I need the subtract of
> Buy with sales and show the balance results.
>
> There is an option "Difference of" but it not showing proper results.
>
> *I Can alternatively put minus signs in all the sales transactions but
> that is not possible for a big database.*
>
> Any easy alternative solution will be highly appreciable.
>
> Thanks in advance.
> B. Sharma
>
> --
Regards
Rajan verma
+91 7838100659

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ List of unique items

[Rajan Verma]

look at the attached file.

On Friday, 27 May 2016 03:47:34 UTC-6, Abhi wrote:
>
> Please share an example workbook.
>
> On Fri, May 27, 2016 at 3:10 PM, Louis Omoya  > wrote:
>
>> Hi all? Thid is my first post in the group. I appreciate the support 
>> online communities such as this offer.
>>
>> To my problem (which i have spent 2 days with no success).
>>
>> I have a column of regions and districts. Each region and district appear 
>> multiple times because there are several health facilities per district.
>> I want to use a formula that will list all unique districts based on a 
>> region drop down list on another work sheet.
>>
>> Pivot table and filter will be last resort. Formulas are more dynamic 
>> which i want in this scenario.
>>
>> Thanks in advance for assistance.
>>
>> Louis..
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com 
>> .
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Book1.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

[Rajan Verma]

in J1

=LOOKUP(1,N(COUNTIF(D2:H2,D2:H2)1))=1

Regards
Rajan.

On Thursday, 25 September 2014 11:15:01 UTC-6, SUDHIR VERMA wrote:

 Dear Experts,

 Kindly resolve my problem.

 Explanation in attached workbook.

 Thanking You

 Regards
 Sudhir


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Please solve this sheet its very urgent

[Rajan Verma]

Wow

On Monday, 11 August 2014 12:57:05 UTC-6, kapil Gupta wrote:

 Thanks you really genius.


 Regards,
 Kapil Gupta

 On Monday, August 11, 2014 3:57:39 PM UTC+5:30, Vabz wrote:

 Hi

 FA

 Cheers!!


 On Mon, Aug 11, 2014 at 1:03 PM, kapil Gupta kgup...@gmail.com wrote:

 Hello,

   Please sheet and question mention in under of sheets.


 Regards,
 Kapil Gupta
  
 -- 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post confidential data in a workbook. Forum owners and 
 members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google 
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send 
 an email to excel-macros...@googlegroups.com.
 To post to this group, send email to excel-...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.




-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: 4 quadrants graph help required

[Rajan Verma]

see the attached.

On Monday, 3 March 2014 01:55:00 UTC-7, rekha siri wrote:

 Hi Friends,

 Please need your expert help in building 4 quadrant graph help.

  
 

 

  Below is data for which 4 quadrant graph  is required.
   
 Company
  
 Spend
  
 Risk
   
 A
  
 10
  
 5%
   
 B
  
 10
  
 30%
   
 C
  
 40
  
 60%
   
 D
  
 100
  
 5%
  


 i am attaching word doc in which i have drawn graph which looks like.

 Please help in this regards.

 Thanks,
 Rekha


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


Book1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Count of 1, 2, 3..... in a range

[Rajan Verma]

Put your number like 1,2,3 in B3 and so on and apply this formula with CSE 
in C3, c4 and so on.

=SUM(N(VALUE(TRIM(MID(SUBSTITUTE($B$1:$FP$1,,,REPT( 
,LEN($B$1:$FP$1))),((ROW(INDIRECT(1:LEN($B$1:$FP$1)))-1)*LEN($B$1:$FP$1)+1),LEN($B$1:$FP$1=B3))

On Saturday, 1 March 2014 04:30:53 UTC-7, KATHIRVELAN N wrote:

 Dear Friends,

 Please help me to count the 1, 2, 3 in row range.

 Thanks,
 Kathirvelan


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Re: Array from range

[Rajan Verma]

you should give column dimension in this below line

BETADEG(s)

it should be like BETADEG(s,1)


On Friday, 28 February 2014 07:23:35 UTC-7, Gerrit Grundling wrote:

 Greetings, all
  
 What am I doing wrong here? I am trying to create an array from a range, 
 but keep getting the Run-time error '9': Subscript out of range warning.
  
 TIP = Application.WorksheetFunction.CountA(ActiveSheet.Range(
 D19:D1048576)) 'Counts the number of active rows below the first 
 assigned row
 Cells(1, 36) = TIP 'Check number of rows - debug only
  'Number of stations i.e. number of rows'
 CHORD = Range(A33:A42)
 Cells(2, 36) = Application.WorksheetFunction.CountA(CHORD) 'Check number 
 of rows - debug only'
 BETADEG = Range(H19:H28) 'Mount angle, degrees'
 Cells(3, 36) = Application.WorksheetFunction.CountA(BETADEG) 'Check 
 number of rows - debug only'
 'Convert mount angles to radians'
 'Dim BETA() As Long'
 ReDim BETA(TIP) As Long
 For s = 1 To TIP
 'BETA(s) = BETADEG(s)'
 Cells(s, 33) = s
 Cells(s, 34) = BETADEG(s)
 Cells(s, 35) = BETA(s)
 Next s

 Clearly I have created BETA correctly, but made a mistake in creating an 
 array BETADEG from the range. If so, than I've created all the arrays 
 incorrectly from the ranges.
  
 Thanks in advance


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Re: Two-dimensional interpolation

[Rajan Verma]

Hi 

make your array as double data type not Long

Thanks
Rajan.




n Wednesday, 26 February 2014 07:07:45 UTC-7, Gerrit Grundling  wrote:

Greetings, all
  
 I have attached some aerofoil data for a Clark Y foil. This data is also 
 available in my spread sheet.
  
 The Reynolds number is given in the heading as 
 5.00E+04, 1.00E+05, 5.00E+05, 1.00E+06 and 3.00E+06. I need to find Cl and 
 Cd at an AoA for a Reynolds number:
  
 GetCl(AoA, Re)
 GetCd(AoA, RE)
  
 Interpolation functions are easy enough to find. 
 Herehttp://www.vbaexpress.com/forum/showthread.php?41522-Linear-Interpolationp=263514viewfull=1#post263514is
  one that also includes sorting. But I need to run this over the 
 two-dimensional array that is the aerofoil data. Not all aerofoil AoA's 
 are the same for the different Re (xfoil was used to obtain this data). 
 This means that creating an array would have blanks at some AoA's, unless I 
 interpolate to fill in the gaps.
  
 I was thinking that I might write a code to create an array of cl and cd 
 for each Re-number at the AoA, but the AoA is not always a neat number. 
 However, neither is the Reynolds number.
  
 How would you do it? Could you use an interpolation function such as the 
 one I linked to (not a preference, so I'm impartial)?
  
 Thanks in advance
  
  


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Excel Formula - Huge Formula - Help to simplfy

[rajan verma]

!$G2,CurrencyRate,0)),SUMIF(
 MiscEntries_AccountClass,$C2,MiscEntries_Day1)/INDEX(
 ExchangeRate,MATCH(METADATA!$G2,CurrencyRate,0))

 
  --
  Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s
  =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
  https://www.facebook.com/discussexcel
 
  FORUM RULES
 
  1) Use concise, accurate thread titles. Poor thread titles, like Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will
  not get quick attention or may not be answered.
  2) Don't post a question in the thread of another member.
  3) Don't post questions regarding breaking or bypassing any security
  measure.
  4) Acknowledge the responses you receive, good or bad.
  5) Jobs posting is not allowed.
  6) Sharing copyrighted material and their links is not allowed.
 
  NOTE : Don't ever post confidential data in a workbook. Forum owners
 and
  members are not responsible for any loss.
  ---
  You received this message because you are subscribed to the Google
 Groups
  MS EXCEL AND VBA MACROS group.
  To unsubscribe from this group and stop receiving emails from it, send
 an
  email to excel-macros...@googlegroups.com.
  To post to this group, send email to excel-...@googlegroups.com.
  Visit this group at http://groups.google.com/group/excel-macros.
  For more options, visit https://groups.google.com/groups/opt_out.

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
Regards
Rajan verma
+91 7838100659

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ how to unhide multiple sheets at once in excel 2007

[rajan verma]

select sheets tab with control button and press alt h h
On 28 Sep 2013 13:04, ashish koul koul.ash...@gmail.com wrote:

 Sub unhide_specific_worksheets()

 Dim abc()
 Dim wk As Worksheet
 Dim i As Integer
 abc = Array(Sheet1, Sheet2)

 For i = LBound(abc) To UBound(abc)
 For Each wk In ThisWorkbook.Sheets
 If wk.Name = abc(i) Then
 wk.Visible = xlSheetVisible
 Exit For
 End If
 Next wk
 Next i
 End Sub



 On Sat, Sep 28, 2013 at 10:53 AM, Prabhu Pinky prabhupin...@gmail.comwrote:

 Hi Experts,

 Is there any way to unhide multiple worksheets at once in excel 2007.
 Please share your inputs.

 Thanks  Regards,
 Prabhu R

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




 --
 *Regards*
 * *
 *Ashish Koul*


 *Visit*
 *My Excel Blog http://www.excelvbamacros.com/*
 Like Us on 
 Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
 Join Us on Facebook http://www.facebook.com/groups/163491717053198/


 P Before printing, think about the environment.



 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ paste special particular formula

[rajan verma]

So problem was the reference in formulas ,  if any formula have reference
like A1:A5 and when it will get evaluate by VBA (i am using Evaluate here)
it will always assume that reference is from activesheet until we provide
full reference like Sheet1!A1:A5, but it is complex to write that code , so
the simple solution would to be to activate that sheet where the formula is
going to be evaluated,

try this code ,


Sub PasteFormula()

Dim rngRange As Range
Dim VarArr
Dim strFormula As String
Dim varEle
Dim lngR As Long
Dim lngC As Long
Dim lngCount As Long
Dim wksSheet As Worksheet
Dim wksLastActive As Worksheet

strFormula = InputBox(Enter formula name to replace with values)
lngCount = 0
Application.ScreenUpdating = False
Set wksLastActive = ThisWorkbook.ActiveSheet
For Each wksSheet In ThisWorkbook.Worksheets
Set rngRange = wksSheet.UsedRange
If Not rngRange Is Nothing Then
VarArr = rngRange.Formula
If IsArray(VarArr) Then
wksSheet.Activate
For lngR = LBound(VarArr) To UBound(VarArr)
For lngC = LBound(VarArr) To UBound(VarArr, 2)
If Not IsEmpty(VarArr(lngR, lngC)) Then
If UCase(VarArr(lngR, lngC)) Like * 
UCase(strFormula)  * Then
VarArr(lngR, lngC) =
Evaluate(VarArr(lngR, lngC))
lngCount = lngCount + 1
End If
End If
Next lngC
Next lngR
wksSheet.UsedRange.Value = VarArr
End If
Set rngRange = Nothing
End If
Next wksSheet
wksLastActive.Activate
Application.ScreenUpdating = True
MsgBox strFormula   has been replaced in   lngCount   Cells,
vbInformation

End Sub



On Fri, Sep 27, 2013 at 12:08 AM, Mukesh Kumar mukeshka...@gmail.comwrote:

 Rajan Ji,

 Plz see attached file. I have inserted the macro code in it. But it is
 giving wrong results. Plz check.

 Regards,
 Mukesh Kumar


 On Thu, Sep 26, 2013 at 9:45 PM, rajan verma rajanverma1...@gmail.comwrote:

 use this one.

 Sub PasteFormula()

 Dim rngRange As Range
 Dim VarArr
 Dim strFormula As String
 Dim varEle
 Dim lngR As Long
 Dim lngC As Long
 Dim lngCount As Long
 Dim wksSheet As Worksheet

 strFormula = InputBox(Enter formula name to replace with values)
 lngCount = 0
 For Each wksSheet In ThisWorkbook.Worksheets
 Set rngRange = wksSheet.UsedRange
 If Not rngRange Is Nothing Then
 VarArr = rngRange.Formula
 If IsArray(VarArr) Then
 For lngR = LBound(VarArr) To UBound(VarArr)
 For lngC = LBound(VarArr) To UBound(VarArr, 2)
 If Not IsEmpty(VarArr(lngR, lngC)) Then
 If UCase(VarArr(lngR, lngC)) Like * 
 UCase(strFormula)  * Then
 VarArr(lngR, lngC) =
 Evaluate(VarArr(lngR, lngC))
 lngCount = lngCount + 1
 End If
 End If
 Next lngC
 Next lngR
 End If
 End If
wksSheet.UsedRange.Value = VarArr
 Next wksSheet

 MsgBox strFormula   has been replaced in   lngCount   Cells,
 vbInformation

 End Sub



 On Thu, Sep 26, 2013 at 10:14 AM, rajan verma 
 rajanverma1...@gmail.comwrote:


 Try this one

 Sub PasteFormula()

 Dim rngRange As Range
 Dim VarArr
 Dim strFormula As String
 Dim varEle
 Dim lngR As Long
 Dim lngC As Long
 Dim lngCount As Long
 Dim wksSheet As Worksheet

 strFormula = InputBox(Enter formula name to replace with values)
 lngCount = 0
 For Each wksSheet In ThisWorkbook.Worksheets
 Set rngRange = wksSheet.UsedRange
 If Not rngRange Is Nothing Then
 VarArr = rngRange.Formula
 If IsArray(VarArr) Then
 For lngR = LBound(VarArr) To UBound(VarArr)
 For lngC = LBound(VarArr) To UBound(VarArr, 2)
 If Not IsEmpty(VarArr(lngR, lngC)) Then
 If UCase(VarArr(lngR, lngC)) Like * 
 UCase(strFormula)  * Then
 VarArr(lngR, lngC) =
 Evaluate(VarArr(lngR, lngC))
 lngCount = lngCount + 1
 End If
 End If
 Next lngC
 Next lngR
 End If
 End If
 Next wksSheet
 ActiveSheet.UsedRange.Value = VarArr
 MsgBox strFormula   has been replaced in   lngCount   Cells,
 vbInformation

 End Sub



 On Thu, Sep 26

Re: $$Excel-Macros$$ paste special particular formula

[rajan verma]

://groups.google.com/groups/opt_out.




-- 
Regards
Rajan verma
+91 7838100659

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ paste special particular formula

[rajan verma]

HI Mukesh

i have seen this query many time on this group and another forums, please
try this macro


Sub PasteFormula()

Dim rngRange As Range
Dim VarArr
Dim strFormula As String
Dim varEle
Dim lngR As Long
Dim lngC As Long
Dim lngCount As Long

Set rngRange = ActiveSheet.UsedRange
VarArr = rngRange.Formula
strFormula = InputBox(Enter formula name to replace with values)
lngCount = 0
For lngR = LBound(VarArr) To UBound(VarArr)
For lngC = LBound(VarArr) To UBound(VarArr, 2)
If Not IsEmpty(VarArr(lngR, lngC)) Then
If UCase(VarArr(lngR, lngC)) Like *  UCase(strFormula) 
* Then
VarArr(lngR, lngC) = Evaluate(VarArr(lngR, lngC))
lngCount = lngCount + 1
End If
End If
Next lngC
Next lngR
ActiveSheet.UsedRange.Value = VarArr
MsgBox strFormula   is replace in   lngCount   Cells,
vbInformation

End Sub



On Thu, Sep 26, 2013 at 3:40 AM, Mukesh Kumar mukeshka...@gmail.com wrote:

 Hi experts,

 I need a macro code to paste special a particular formula across many
 sheets. Every sheet contains different types of formulas, but i have to
 paste special a particular /specific formula.


 Please help me out.


 Regards,
 Mukesh Kumar

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
Regards
Rajan verma
+91 7838100659

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ paste special particular formula

[rajan verma]

Try this one

Sub PasteFormula()

Dim rngRange As Range
Dim VarArr
Dim strFormula As String
Dim varEle
Dim lngR As Long
Dim lngC As Long
Dim lngCount As Long
Dim wksSheet As Worksheet

strFormula = InputBox(Enter formula name to replace with values)
lngCount = 0
For Each wksSheet In ThisWorkbook.Worksheets
Set rngRange = wksSheet.UsedRange
If Not rngRange Is Nothing Then
VarArr = rngRange.Formula
If IsArray(VarArr) Then
For lngR = LBound(VarArr) To UBound(VarArr)
For lngC = LBound(VarArr) To UBound(VarArr, 2)
If Not IsEmpty(VarArr(lngR, lngC)) Then
If UCase(VarArr(lngR, lngC)) Like * 
UCase(strFormula)  * Then
VarArr(lngR, lngC) =
Evaluate(VarArr(lngR, lngC))
lngCount = lngCount + 1
End If
End If
Next lngC
Next lngR
End If
End If
Next wksSheet
ActiveSheet.UsedRange.Value = VarArr
MsgBox strFormula   has been replaced in   lngCount   Cells,
vbInformation

End Sub



On Thu, Sep 26, 2013 at 6:37 AM, Mukesh Kumar mukeshka...@gmail.com wrote:

 Rajan ji , this macro code is limited to one sheet only. I want the macro
 that works upon all sheets at once.

 Regards,
 Mukesh Kumar


 On Thu, Sep 26, 2013 at 3:39 PM, rajan verma rajanverma1...@gmail.comwrote:

 HI Mukesh

 i have seen this query many time on this group and another forums, please
 try this macro


 Sub PasteFormula()

 Dim rngRange As Range
 Dim VarArr
 Dim strFormula As String
 Dim varEle
 Dim lngR As Long
 Dim lngC As Long
 Dim lngCount As Long

 Set rngRange = ActiveSheet.UsedRange
 VarArr = rngRange.Formula
 strFormula = InputBox(Enter formula name to replace with values)
 lngCount = 0
 For lngR = LBound(VarArr) To UBound(VarArr)
 For lngC = LBound(VarArr) To UBound(VarArr, 2)
 If Not IsEmpty(VarArr(lngR, lngC)) Then
 If UCase(VarArr(lngR, lngC)) Like *  UCase(strFormula)
  * Then
 VarArr(lngR, lngC) = Evaluate(VarArr(lngR, lngC))
 lngCount = lngCount + 1
 End If
 End If
 Next lngC
 Next lngR
 ActiveSheet.UsedRange.Value = VarArr
 MsgBox strFormula   is replace in   lngCount   Cells,
 vbInformation

 End Sub



 On Thu, Sep 26, 2013 at 3:40 AM, Mukesh Kumar mukeshka...@gmail.comwrote:

 Hi experts,

 I need a macro code to paste special a particular formula across many
 sheets. Every sheet contains different types of formulas, but i have to
 paste special a particular /specific formula.


 Please help me out.


 Regards,
 Mukesh Kumar

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




 --
 Regards
 Rajan verma
 +91 7838100659

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members

Re: $$Excel-Macros$$ paste special particular formula

[rajan verma]

use this one.

Sub PasteFormula()

Dim rngRange As Range
Dim VarArr
Dim strFormula As String
Dim varEle
Dim lngR As Long
Dim lngC As Long
Dim lngCount As Long
Dim wksSheet As Worksheet

strFormula = InputBox(Enter formula name to replace with values)
lngCount = 0
For Each wksSheet In ThisWorkbook.Worksheets
Set rngRange = wksSheet.UsedRange
If Not rngRange Is Nothing Then
VarArr = rngRange.Formula
If IsArray(VarArr) Then
For lngR = LBound(VarArr) To UBound(VarArr)
For lngC = LBound(VarArr) To UBound(VarArr, 2)
If Not IsEmpty(VarArr(lngR, lngC)) Then
If UCase(VarArr(lngR, lngC)) Like * 
UCase(strFormula)  * Then
VarArr(lngR, lngC) =
Evaluate(VarArr(lngR, lngC))
lngCount = lngCount + 1
End If
End If
Next lngC
Next lngR
End If
End If
   wksSheet.UsedRange.Value = VarArr
Next wksSheet

MsgBox strFormula   has been replaced in   lngCount   Cells,
vbInformation

End Sub



On Thu, Sep 26, 2013 at 10:14 AM, rajan verma rajanverma1...@gmail.comwrote:


 Try this one

 Sub PasteFormula()

 Dim rngRange As Range
 Dim VarArr
 Dim strFormula As String
 Dim varEle
 Dim lngR As Long
 Dim lngC As Long
 Dim lngCount As Long
 Dim wksSheet As Worksheet

 strFormula = InputBox(Enter formula name to replace with values)
 lngCount = 0
 For Each wksSheet In ThisWorkbook.Worksheets
 Set rngRange = wksSheet.UsedRange
 If Not rngRange Is Nothing Then
 VarArr = rngRange.Formula
 If IsArray(VarArr) Then
 For lngR = LBound(VarArr) To UBound(VarArr)
 For lngC = LBound(VarArr) To UBound(VarArr, 2)
 If Not IsEmpty(VarArr(lngR, lngC)) Then
 If UCase(VarArr(lngR, lngC)) Like * 
 UCase(strFormula)  * Then
 VarArr(lngR, lngC) =
 Evaluate(VarArr(lngR, lngC))
 lngCount = lngCount + 1
 End If
 End If
 Next lngC
 Next lngR
 End If
 End If
 Next wksSheet
 ActiveSheet.UsedRange.Value = VarArr
 MsgBox strFormula   has been replaced in   lngCount   Cells,
 vbInformation

 End Sub



 On Thu, Sep 26, 2013 at 6:37 AM, Mukesh Kumar mukeshka...@gmail.comwrote:

 Rajan ji , this macro code is limited to one sheet only. I want the macro
 that works upon all sheets at once.

 Regards,
 Mukesh Kumar


 On Thu, Sep 26, 2013 at 3:39 PM, rajan verma rajanverma1...@gmail.comwrote:

 HI Mukesh

 i have seen this query many time on this group and another forums,
 please try this macro


 Sub PasteFormula()

 Dim rngRange As Range
 Dim VarArr
 Dim strFormula As String
 Dim varEle
 Dim lngR As Long
 Dim lngC As Long
 Dim lngCount As Long

 Set rngRange = ActiveSheet.UsedRange
 VarArr = rngRange.Formula
 strFormula = InputBox(Enter formula name to replace with values)
 lngCount = 0
 For lngR = LBound(VarArr) To UBound(VarArr)
 For lngC = LBound(VarArr) To UBound(VarArr, 2)
 If Not IsEmpty(VarArr(lngR, lngC)) Then
 If UCase(VarArr(lngR, lngC)) Like * 
 UCase(strFormula)  * Then
 VarArr(lngR, lngC) = Evaluate(VarArr(lngR, lngC))
 lngCount = lngCount + 1
 End If
 End If
 Next lngC
 Next lngR
 ActiveSheet.UsedRange.Value = VarArr
 MsgBox strFormula   is replace in   lngCount   Cells,
 vbInformation

 End Sub



 On Thu, Sep 26, 2013 at 3:40 AM, Mukesh Kumar mukeshka...@gmail.comwrote:

 Hi experts,

 I need a macro code to paste special a particular formula across many
 sheets. Every sheet contains different types of formulas, but i have to
 paste special a particular /specific formula.


 Please help me out.


 Regards,
 Mukesh Kumar

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links

Re: $$Excel-Macros$$ Array - Unique list

[rajan verma]

Visit here

http://excelpoweruser.wordpress.com/2011/08/09/get-unique-list-another-method/

For more method to get unique see this

http://excelpoweruser.wordpress.com/?s=Unique+list




On Wed, Sep 25, 2013 at 8:32 AM, Chandra Shekar 
chandrashekarb@gmail.com wrote:

 Hello,

 Am trying to extract unique values using array but am not getting correct
 count. I have attached the excel in Sheet1 there is main data, in sheet2 am
 getting values after running macros and in sheet3 colored cells is the
 orginal value and in Column C I have put countif formula which is not
 matching.

 Could you please check what is the issue?


 Thanks in advance


 Regards,

 Chandra

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
Regards
Rajan verma
+91 7838100659

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Facing 'run-time error -2147217871 (80040e31) Automation error' in excel VBA

[rajan verma]

recheck your connection string
and where you are getting this error
On 25 Sep 2013 12:26, Junaid junaid.an...@gmail.com wrote:

 Hi guys,

 I am working on Excel 2007 macros. My requirement is to access MS SQL
 server DB from excel, using VBA. I am just trying to pull some data by
 connecting to DB, but facing this issue: 'Facing 'run-time error -
 2147217871 (80040e31) Automation error' in excel VBA'

 Below is the chunk of code I am using:

 Dim objMyConn
 Set objMyConn = New ADODB.Connection
 Dim objMyRecordset As New Recordset
 Set objMyRecordset = New ADODB.Recordset
 Dim strConnectionString As String
 Dim strSQL As String

 strConnectionString = {connectionStringDetails}


 strSQL = select top 10 * from {table name} where server = '{columnName}'
 order by 1 desc

 objMyConn.Open strConnectionString

 objMyRecordset.Open strSQL, objMyConn

 ActiveSheet.Range(A4).CopyFromRecordset objMyRecordset

 Any help is appreciated. Thanks.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Need a Fastest way

[rajan verma]

can anyone suggest a faster way to know which cells are highlighted in a
Range ?

suppose i  have data of 1 lac cell and i have some cells highlighted , i
want to know address of that cells.



-- 
Regards
Rajan verma
+91 9158998701

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Re: bubbel chart help required.

[rajan verma]

do you really think that will work what you have in excel?? think again.

On Fri, Mar 22, 2013 at 9:02 AM, Sara Lee lee.sar...@gmail.com wrote:

 This is already present in excel on tool bar.. no need of code actually

 On Fri, Mar 22, 2013 at 7:49 AM, Rajan_Verma rajanverma1...@gmail.comwrote:

 I have ready code for this

 http://excelpoweruser.wordpress.com/2012/09/03/bubble-chart/



 On Thursday, 21 March 2013 00:46:03 UTC-6, midhun wrote:

 hi all;

 i want to create the bubble chart of the following data.
 not able to create as all the data is not reflecting.
 also the x axis should display high ir low instead of the number.
 kindly help me out.

 --
 Midhun Thampan.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.




  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to a topic in the
 Google Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this topic, visit
 https://groups.google.com/d/topic/excel-macros/iCK8rG__1Uw/unsubscribe?hl=en
 .
 To unsubscribe from this group and all its topics, send an email to
 excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.






-- 
Regards
Rajan verma
+91 9158998701

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ My Excel is Crashing!!

[rajan verma]

New thread

i know , every user face it
lets post here the possible reasons of crashing excel and find out the way
to get rid of it.


-- 
Regards
Rajan verma
+91 9158998701

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ I want to merge two text cell

[rajan verma]

i think you are very very beginner  in excel

=Concatenate(A1,A2)
=A1  A2


On Wed, Mar 6, 2013 at 4:51 AM, Dhaval Shah todhavals...@gmail.com wrote:

 dear friends

 i want to merge two text cell in one

 pls refer the sheet

 thanks

 dhaval


  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.






-- 
Regards
Rajan verma
+91 9158998701

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Need to Subtract Two Date/Time Cells - Formula Issue

[rajan verma]

Just remove starting space from the date

On Tue, Mar 5, 2013 at 9:54 AM, John A. Smith johnasmit...@gmail.comwrote:

 I have a download into Excel with start and stop cells which contain the
 date/time.  I need help making my formula work please to get the NET
 minutes.

 Please see my attached problem example.

 Thank you for being here (again).

 Very Grateful,

 John

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.






-- 
Regards
Rajan verma
+91 9158998701

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ shuffle cell value in excel

[rajan verma]

so you want all possible unique combination??

On Tue, Mar 5, 2013 at 10:11 AM, xlstime xlst...@gmail.com wrote:

 Hi Guys,

 is it possible to shuffle cell value

 for example

 cell a1 value is 1234

  i want 4321,2134,4123 like



 Thanks in advance
 .

 Enjoy
 Team XLS




  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.






-- 
Regards
Rajan verma
+91 9158998701

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Query

[rajan verma]

neeraj, very bad subject and query explaination

On Fri, Feb 8, 2013 at 2:17 AM, neeraj chauhan
neerajchauhan...@gmail.comwrote:

 thanks sir,

 its working thanks again


 On Fri, Feb 8, 2013 at 2:16 PM, NOORAIN ANSARI 
 noorain.ans...@gmail.comwrote:

 Dear Neeraj,

 You can use..

 =EDATE(A2,6)

 or

 =DATE(YEAR(A2),MONTH(A2)+6,DAY(A2))



 On Fri, Feb 8, 2013 at 1:35 PM, neeraj chauhan 
 neerajchauhan...@gmail.com wrote:

 Dear Experts,

 kindly find the attached sheet i want the add the 6 or 7 months in
 particular date.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.






 --
 With Regards,
 Noorain Ansari
 http:// 
 http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
 http:// 
 http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.




  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.






-- 
Regards
Rajan verma
+91 9158998701

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick

Re: $$Excel-Macros$$ IF Problem

[rajan verma]

see if it help , i did it by CF

On Fri, Feb 8, 2013 at 9:04 AM, Kenil Gala keni...@yahoo.com wrote:

 Hi group,
 I have a small IF related query.

 i want an answer for two logical tests at a same time. Pls chk my file
 attached.

 Thanks in adv.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.






-- 
Regards
Rajan verma
+91 9158998701

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




IF Problem.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Match a Word in a cell using Macros

[rajan verma]

SORRY FOR LONG FORMULA, BUT INSTANT

=INDEX(Database!$A$2:$A$23,IF(MAX(IFERROR(MATCH(TRIM(MID(SUBSTITUTE(A2,
,REPT(
,LEN(A2))),((ROW($1:$4)-1)*LEN(A2))+1,LEN(A2))),Database!$A$2:$A$23,0),-))=0,NA(),MAX(IFERROR(MATCH(TRIM(MID(SUBSTITUTE(A2,
,REPT(
,LEN(A2))),((ROW($1:$4)-1)*LEN(A2))+1,LEN(A2))),Database!$A$2:$A$23,0),-))),1)
WITH CSE

On Thu, Feb 7, 2013 at 6:48 AM, vijayajith VA vijayajith...@gmail.comwrote:

 HI Santhuash,



 =IFERROR(IF(FIND( ,A2)-1  1,VLOOKUP(LEFT(A2,FIND(
 ,A2)-1)*,Database!A:A,1,0),),)

 Try this. hope it helps you, Thanks

 On Wed, Feb 6, 2013 at 7:39 PM, Santhosh Kumar M K mks@gmail.comwrote:

 Hi Friends,

 Need a help to create macro in a Data tab where it can recongnize a
 word either by first/middle/last name if not with full name.

 for ex - SHANGHAI ERICSSON SIMTEK  in Database tab should help to
 match the data even by recognizing any one word of this full name from
 Data tab and incase if it matches then it should reflect in column B of
 Data tab

 Please find attachment.

 Regards,
 Santhosh

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.




  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.






-- 
Regards
Rajan verma
+91 9158998701

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Enquiry about VBA

[rajan verma]

it looks good,

On Thu, Feb 7, 2013 at 5:47 AM, Manjunath Narayanappa 
manjunath.narayana...@aon.co.uk wrote:

  Dear Experts,



 I been to one of the academy to enquiry above VBA  Macros, please find
 the attached broacher

 I'm not aware anything abt it  I want to learn VBA  Macros. please guide
 me



 Thanks

 Manjunath



 --

 PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



 For Aon’s standard conditions associated with this e-mail please visit
 http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp

 Aon UK Limited

 Registered Office: 8 Devonshire Square, London EC2M 4PL

 Registered in London No. 210725 . VAT Registration No. 480 8401 48



 Aon UK Limited is authorised and regulated by the Financial Services
 Authority in respect of insurance mediation activities only.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.






-- 
Regards
Rajan verma
+91 9158998701

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member Jan'13

[rajan verma]

 for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.




  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.






-- 
Regards
Rajan verma
+91 9158998701

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Getting Email Pattern

[rajan verma]

I am wondering if someone can suggest a smart solution to identify the
pattern of email id.


  Name ID pattern  Ravi verma ravi.ve...@gmail.com fff@gmail.com  Ravi
verma rve...@gmail.com f...@gmail.com  Ravi verma r.ve...@gmail..com
f@gmail.com  Ravi verma rav...@gmail.com ff...@gmail.com


-- 
Regards
Rajan verma
+91 9158998701

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Getting Email Pattern

[rajan verma]

ashish , can you explain

On Fri, Feb 1, 2013 at 10:27 AM, koul.ash...@gmail.com wrote:

 **
 Use

 Fn first name
 Fni or fi first intial
 Ln last name
 Lni or li last name intial
 Sent on my BlackBerry® from Vodafone
 --
 *From: * rajan verma rajanverma1...@gmail.com
 *Sender: * excel-macros@googlegroups.com
 *Date: *Fri, 1 Feb 2013 09:59:08 -0700
 *To: *excel-macros@googlegroups.com
 *ReplyTo: * excel-macros@googlegroups.com
 *Subject: *$$Excel-Macros$$ Getting Email Pattern

 I am wondering if someone can suggest a smart solution to identify the
 pattern of email id.


   Name ID pattern  Ravi verma ravi.ve...@gmail.com fff@gmail.com  Ravi
 verma rve...@gmail.com f...@gmail.com  Ravi verma r.ve...@gmail..com
 f@gmail.com  Ravi verma rav...@gmail.com ff...@gmail.com


 --
 Regards
 Rajan verma
 +91 9158998701

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.



 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.






-- 
Regards
Rajan verma
+91 9158998701

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Certification

[rajan verma]

nobody will see excel certificate i think

On Thu, Jan 31, 2013 at 7:58 AM, Manjunath Narayanappa 
manjunath.narayana...@aon.co.uk wrote:

  Dear Team,



 Is there any online excel exam to get certified.



 Thanks

 Manjunath

 --

 PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



 For Aon’s standard conditions associated with this e-mail please visit
 http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp

 Aon UK Limited

 Registered Office: 8 Devonshire Square, London EC2M 4PL

 Registered in London No. 210725 . VAT Registration No. 480 8401 48



 Aon UK Limited is authorised and regulated by the Financial Services
 Authority in respect of insurance mediation activities only.

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.






-- 
Regards
Rajan verma
+91 9158998701

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ HyperLinks to Sheets

[rajan verma]

Sub CreateLinksToAllSheets()
Dim sh As Worksheet
Dim cell As Range
For Each sh In ActiveWorkbook.Worksheets
If ActiveSheet.Name  sh.Name Then
ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:=,
SubAddress:= _
'  sh.Name  '  !A1, TextToDisplay:=sh.Name
 if activeCell.row mod 30 =0 then
ActiveCell.Offset(1, 1).Select
else
ActiveCell.Offset(1, 0).Select
endif
End If
Next sh
End Sub


On Wed, Jan 16, 2013 at 5:33 AM, Hilary Lomotey resp...@gmail.com wrote:


 Sub CreateLinksToAllSheets()
 Dim sh As Worksheet
 Dim cell As Range
 For Each sh In ActiveWorkbook.Worksheets
 If ActiveSheet.Name  sh.Name Then
 ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:=,
 SubAddress:= _
 '  sh.Name  '  !A1, TextToDisplay:=sh.Name
 ActiveCell.Offset(1, 0).Select
 End If
 Next sh
 End Sub





-- 
Regards
Rajan verma
+91 9158998701

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Conditional Concatenate

[rajan verma]

Hi
Please find attachement

Rajan

On Fri, Jan 11, 2013 at 12:49 AM, Satendra kumar
satendrakuma...@gmail.comwrote:

 Dear Rajan ji,

 Please find attachment  solve ,

 thankx
 satendra


 On Fri, Jan 11, 2013 at 1:13 PM, rajan verma rajanverma1...@gmail.comwrote:

 can be done with using concatenate function
 =A1,B1,C1,D1

 Rajan

 On Thu, Jan 10, 2013 at 11:53 PM, Satendra kumar 
 satendrakuma...@gmail.com wrote:

 Dear Anil,

 i have large database so how to define colored range??



 =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE(O2,,,O3,,,O4,,,O5
 ),),)





 On Fri, Jan 11, 2013 at 11:50 AM, अनिल नारायण गवली 
 gawlianil8...@gmail.com wrote:

 Dear Satendrakumar,

 use this =CONCATENATE(A1,B1,C1,D1)
 if u want , in between.

 or else share the workbook wit us.

 Warm Regards,
 Gawli Anil

 On Fri, Jan 11, 2013 at 11:45 AM, Satendra kumar 
 satendrakuma...@gmail.com wrote:

 Dear Expert,

 Solve this query..i want automate colored range. if you have any
 solution please provide. Like Exce.



 =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE(O2,,,O3,,,O4,,,O5
 ),),)




 Thanks  Regards
 Satendra Kumar

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






 --
 Thanks  Regards,
 Gawli Anil Narayan
 Software Developer,
 Abacus Software Services Pvt Ltd




 --
 Thanks  Regards
 Satendra Kumar

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






 --
 Regards
 Rajan verma
 +91 9158998701

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






 --
 Thanks  Regards
 Satendra Kumar

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member December'12

[rajan verma]

Glad to see this mail for you, keep it up good work..
Congrats :)

Rajan verma


On Fri, Jan 11, 2013 at 12:10 AM, amar takale amartak...@gmail.com wrote:

 Dear Prince,


 Congratulations my friend, well done and keep it up excellent work for our
 group.


 Warm Regards,
 Amar


 On Fri, Jan 11, 2013 at 11:32 AM, अनिल नारायण गवली 
 gawlianil8...@gmail.com wrote:

 heartly congratulations prince.

 Warm Regards,
 Gawli Anil

 On Fri, Jan 11, 2013 at 11:04 AM, NOORAIN ANSARI 
 noorain.ans...@gmail.com wrote:

 Congrats Prince Babu...


 --
 With Regards,
 Noorain Ansari
 http:// 
 http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
 http:// 
 http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com


 On Thu, Jan 10, 2013 at 10:19 PM, Ayush Jain jainayus...@gmail.comwrote:

  Dear members,

 Prince Kumar has been selected as 'Most Helpful Member' for the month
 of Dec'12. He has posted 92 posts last month and helped forum members
 through his excel expertise.
 I truly appreciate his technical knowledge, consistency and commitment
 to the group. He has been consistently contributing in the forum since last
 6 months.

 *Prince, please find enclosed the award certificate in honor of your
 contribution. Congratulations and thanks for your commitment.
 We are honored to have you in this forum.
 *

 Thanks to Ashish, Pravin, Paul, Amar, Anoop and all other members for
 helping excel enthusiasts voluntarily !!

 Keep posting.

 Regards,
 Ayush Jain
 Group Manager

 P.S. If you have any feedback, please share your thoughts by filling
 the survey 
 formhttps://docs.google.com/spreadsheet/viewform?fromEmail=trueformkey=dHpYdmtTeWZBcEhDWDhmandNWDlpYXc6MQ.


   --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.







  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






 --
 Thanks  Regards,
 Gawli Anil Narayan
 Software Developer,
 Abacus Software Services Pvt Ltd

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http

Re: $$Excel-Macros$$ Conditional Concatenate

[rajan verma]

can be done with using concatenate function
=A1,B1,C1,D1

Rajan

On Thu, Jan 10, 2013 at 11:53 PM, Satendra kumar
satendrakuma...@gmail.comwrote:

 Dear Anil,

 i have large database so how to define colored range??



 =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE(O2,,,O3,,,O4,,,O5
 ),),)





 On Fri, Jan 11, 2013 at 11:50 AM, अनिल नारायण गवली 
 gawlianil8...@gmail.com wrote:

 Dear Satendrakumar,

 use this =CONCATENATE(A1,B1,C1,D1)
 if u want , in between.

 or else share the workbook wit us.

 Warm Regards,
 Gawli Anil

 On Fri, Jan 11, 2013 at 11:45 AM, Satendra kumar 
 satendrakuma...@gmail.com wrote:

 Dear Expert,

 Solve this query..i want automate colored range. if you have any
 solution please provide. Like Exce.



 =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE(O2,,,O3,,,O4,,,O5
 ),),)




 Thanks  Regards
 Satendra Kumar

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






 --
 Thanks  Regards,
 Gawli Anil Narayan
 Software Developer,
 Abacus Software Services Pvt Ltd




 --
 Thanks  Regards
 Satendra Kumar

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






-- 
Regards
Rajan verma
+91 9158998701

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Unsubscribe my email id

[rajan verma]

To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.

On Mon, Dec 24, 2012 at 1:13 PM, jaspreet singh jas_sar...@yahoo.comwrote:

 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.




-- 
Regards
Rajan verma
+91 9158998701

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ formula

[rajan verma]

) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --
 To post to this group, send email to excel-macros@googlegroups.com



-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Fill Color in Shape

[rajan verma]

Sub FillColor()
dim sh as shape
set sh= activeSheet.shapes(MyShape)
sh.fill.forecolor=rgb(255,0,0)
end Sub


On Sun, Jan 1, 2012 at 5:24 PM, bhupendra singh raghav 
raghav.bhupen...@gmail.com wrote:

 Hi Group,
 Excel is not recording macro to work with shapes .How to fill Color in
 shapes by VBA

 Regards
 Raghav

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel - Cell color actions

[rajan verma]

 of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Disable delete

[rajan verma]

Thanks its also useful to me

Thanks
Rajan.

On Fri, Dec 30, 2011 at 10:09 AM, Prakash Gusain gusainprak...@gmail.comwrote:

 Thanks Asa it solved the issue!

 On Dec 27, 7:33 am, Asa Rossoff a...@lovetour.info wrote:
  Since deleting is done through the operating system, network (if
  applicable), and file system, This needs to be configured using file and
  network permissions.
 
  Here's an example advanced file permissions dialog under Windows 7,
 which
  allows specifically limiting delete file access:
 
  You can set permissions for entire network shares, entire folders, and
 for
  specific files.  Permissions can be set for individual users, for
 specific
  groups of users, and for everyone.
 
  If the files are on a corporate network, usually you need to request the
  network administrators to change permissions.  The simplest
 configuration is
  usually to have a specific network share for the project that most users
  have limited access to (can't delete, possibly even read-only access if
  appropriate) and you and/or the project developers have full access to.
 
  Asa
 
  -Original Message-
  From: excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com]
 
  On Behalf Of Prakash Gusain
  Sent: Sunday, December 25, 2011 9:54 PM
  To: MS EXCEL AND VBA MACROS
  Subject: $$Excel-Macros$$ Disable delete
 
  How can I disable the delete of an excel file?  I don't want my user
 
  to delete the excel file kept at a location.
 
  Thanks in advance.
 
  --
 
  FORUM RULES (934+ members already BANNED for violation)
 
  1) Use concise, accurate thread titles. Poor thread titles, like Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will
  not get quick attention or may not be answered.
 
  2) Don't post a question in the thread of another member.
 
  3) Don't post questions regarding breaking or bypassing any security
  measure.
 
  4) Acknowledge the responses you receive, good or bad.
 
  5)  Cross-promotion of, or links to, forums competitive to this forum in
  signatures are prohibited.
 
  NOTE  : Don't ever post personal or confidential data in a workbook.
 Forum
  owners and members are not responsible for any loss.
 
 
 
  --
 
  To post to this group, send email to excel-macros@googlegroups.com
 
 
 
   image001.png
  66KViewDownload
 
   image002.jpg
  28KViewDownload

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ dob

[rajan verma]

Datedif doest not appear in function list but its exist in Excel..

Thanks

On Thu, Dec 29, 2011 at 1:55 AM, Maries talk2mar...@gmail.com wrote:

 http://www.cpearson.com/excel/datedif.aspx


 On Thu, Dec 29, 2011 at 12:09 AM, Aamir Shahzad 
 aamirshahza...@gmail.comwrote:

 Dear Rajan,

 Perhaps there is no function datedif available in excel 2010, but when
 I copy your formula it's work. Can you brief:

 Aamir Shahzad


 On Wed, Dec 28, 2011 at 6:41 PM, Rajan_Verma rajanverma1...@gmail.comwrote:

  If Current Date in A1 and Date of Birth in B2 then Put this Function
 to Calculate Age:

 =DATEDIF(B2,B1,Y) Year DATEDIF(B2,B1,YM) Month
 DATEDIF(B2,B1,MD) Days



 Please visit this page :

 http://excelpoweruser.blogspot.com/2011/12/age-calculation.html





 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Ansar Ellahi
 *Sent:* Dec/Wed/2011 11:11
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ dob



 please send excel formula
 my accurate date of birth
 from 16/03/1986
 today 28/12/2011

 thanks

 --

 best regards.

 Ansar Ellahi
 Management Office
 *SML-Bhone (Jhang)
 *Cell +92 303 790 2645
 Ph   048-6889211-12
 Fax  048-6889213

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com
  --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




 --

 Regards,

 Aamir Shahzad

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


   --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention

Re: $$Excel-Macros$$ Macro work

[rajan verma]

Hi ronak..
you can mail your query on group .

Rajan

On Wed, Dec 14, 2011 at 2:47 PM, Ronak Hindocha 
ronak.hindo...@futurewise.co.in wrote:

 Hi,

 I have a small macro work. We already have a macro but requires some
 editing. Can some one please help?  I can share more details.

 My contact details are: 99874 12342/ ronak.hindo...@futurewise.co.in

 Ronak Hindocha
 CEO  Founder
 Futurewise Financial Planners
 http://www.futurewise.co.in

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ COUNT Unique using Frequency

[rajan verma]

hi
use this Function to Count only Unique value in a List
{=SUM(IF(COUNTIF(A1:A24,A1:A24)=1,1,0))}

On 12/14/11, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
 PFA

 On Wed, Dec 14, 2011 at 10:32 PM, NOORAIN ANSARI
 noorain.ans...@gmail.comwrote:

 Dear Darwin,

 Please find attached sheet...hope it will help to u...

  On Wed, Dec 14, 2011 at 9:10 PM, Darwin Chan darwin.chankaw...@gmail.com
  wrote:

 Dear all,

 I have a excel table with duplicate bill id, i want to get the unique
 count. However, it should also consider another criteria, which is
 customer. Should I use advanced filter instead? How should the advanced
 filter be set?

 --
 Darwin Chan
 darwin.chankaw...@gmail.com
 kw42c...@yahoo.com.hk

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




 --
 Thanks  regards,
 Noorain Ansari

 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/




 --
 Thanks  regards,
 Noorain Ansari
 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
 *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --
 To post to this group, send email to excel-macros@googlegroups.com



-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Cell editing VBA

[rajan verma]

Try this :


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 And Target.Cells.Count = 1 Then
If Target.Value   Then Target.Offset(, 3).Activate
End If
End Sub





On 12/14/11, dguillett1 dguille...@gmail.com wrote:
 right click sheet tabview codecopy/paste thissave file as .xls or .xlsm
 to allow macros.

 Private Sub Worksheet_Change(ByVal Target As Range)
 If Target.Count  1 Or Target.Column  2 Then Exit Sub
 Target.Offset(, 3).Select
 End Sub


 Don Guillett
 SalesAid Software
 dguille...@gmail.com

 From: hemal shah
 Sent: Wednesday, December 14, 2011 6:24 AM
 To: excel-macros@googlegroups.com
 Subject: $$Excel-Macros$$ Cell editing VBA

 Question : In attached excel sheet, there are  columns named GRN and Recd
 Qty.
 I want VBA code for Reced Qty column's cell .. as soon as GRN cell is filled
 Recd Qty's cell is activatied, else no..



 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --
 To post to this group, send email to excel-macros@googlegroups.com

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --
 To post to this group, send email to excel-macros@googlegroups.com



-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ How to create a double click using VBA CODE without actually double clicking on the mouse

[rajan verma]

hi
what do you want instead of Double Click.. when event will be fire?

Rajan

On 12/14/11, dguillett1 dguille...@gmail.com wrote:
 I do not understand what you want. Send a file with a full explanation and
 examples.

 Don Guillett
 SalesAid Software
 dguille...@gmail.com

 From: Aju Chacko
 Sent: Wednesday, December 14, 2011 12:24 AM
 To: excel macro forum
 Subject: $$Excel-Macros$$ How to create a double click using VBA CODE
 without actually double clicking on the mouse

 Dear experts,
 Kindly help me with vba code for the following problem
 ,I have created a macro that trap the event DOUBLE CLICKING of mouse,But i
 want to optimize in such a way that the user need not double click each time
 with the mouse,Instead I want to create double click of mouse using VBA
 CODE,so when this code create double click event ,the code written for this
 event will get fired.

 Thanking you
 in advance

   Aju V Chacko


 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --
 To post to this group, send email to excel-macros@googlegroups.com

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --
 To post to this group, send email to excel-macros@googlegroups.com



-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ No. of Occurrence of char in string

[rajan verma]

VBA Function Provided By Noorian is nice trick

Try This  with Shift +Ctrl+Enter
=SUM(IF(--CODE(MID(B3,ROW(INDIRECT(A1:ALEN(B3))),1))=CODE(C3),1,0))

On Mon, Dec 12, 2011 at 8:00 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Dear Hanumant,

 Please try it..

 *Function Count_character(rng As Range)
 Dim str As Variant
 str = Split(rng, e)
 Count_character = UBound(str)
 End Function
 *

 --
 Thanks  regards,
 Noorain Ansari
  *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
   On Sat, Dec 10, 2011 at 1:40 AM, hanumant shinde arsfan2...@yahoo.co.in
  wrote:

  Hi All,

 it was an interview que.

 how will you find number of occurrence of any character from string.
 he said you can do it using 1 excel formula or you can use VBA.

 can somebody tell me the answer in both Excel as well as in VBA.

 eg. if string is excel then there are 2 es in this string.

 Thanks,
 Hanumant.

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com





 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Re: Convert XLS to XML

[rajan verma]

Try to recod the macro while saving your file in Xml format


ChDir C:\Users\Administrator\Desktop
ActiveWorkbook.SaveAs
Filename:=C:\Users\Administrator\Desktop\Book1.xml, _
FileFormat:=xlXMLSpreadsheet, ReadOnlyRecommended:=False,
CreateBackup:= _
False


On Mon, Dec 12, 2011 at 5:35 PM, Iqbal Merchant iqbalmerch...@gmail.comwrote:

 Hi Gurus,
 Kindly help for the below query.

 Regards,

 Iqbal

 On Fri, Dec 9, 2011 at 12:35 PM, Iqbal Merchant 
 iqbalmerch...@gmail.comwrote:

 Hi Gurus,
 I need a macro to convert the content of the file into xml format and the
 converted file should get saved on desktop in .xml format.
 Sample file attached.
 Please help!
 --
 Regards

 Iqbal Merchant





 --
 Regards

 Iqbal Merchant


 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ text assignment to the textbox control

[rajan verma]

check if your textbox name is text1

you can attached your file in mail..

On Sat, Dec 10, 2011 at 9:17 PM, Shankar Bheema shankar.n...@gmail.comwrote:

 Dear experts Good morning,

 I am trying to assign a FIXED TEXT for a TEXTBOX1 Control in MSACCESS
 2003.  I have given a code line like:


 text1.text=Good Morning

 But it is not assigning the text given in strings.  Pls suggest me how to
 assign a fixed text to a text box control.

 Thank you.


  --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Conditional Formatting using named ranges

[rajan verma]

hi
can you not refer your named range in conditional formatting.

On Thu, Dec 8, 2011 at 4:22 AM, Rohan bittu.ro...@gmail.com wrote:

 Not figured out what your macro ishowever what I can suggest you
 can use the Offset function to have the range of the
 Conditional formating extended automatically.

 Use, =Offset(A1, Counta(A:A), 0), assuming you want to apply
 conditional formatting in the column A.

 Put the above stated formula in the Conditonal Formatting dialog box,
 where it says Applies to


 Lemme know, if you have questions.


 Rohan.

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

[rajan verma]

hi
please use this Array Function with Shift+Ctrl+Enter
={SUM(VALUE(LEFT(E2:E18,LEN(E2:E18)-1)))}

On Wed, Dec 7, 2011 at 2:45 PM, Maries talk2mar...@gmail.com wrote:


 Hi Lakshman,

 Please use the below codes:

 Sub Right_Delete()
 ' This module will delete text from Right in selected cells.
 Dim MyCell As Range
 Dim Total_Chars As Integer
 On Error Resume Next
 Total_Chars = 2
 For Each MyCell In Selection.Cells
 If Len(MyCell.Value)  Total_Chars Then
 MyCell.Value = Mid(MyCell.Value, 1, Len(MyCell.Value)
 - Total_Chars)
 End If
 Next
 On Error GoTo 0
 End Sub

 Regards,

 MARIES.
 +971559828492
   On Wed, Dec 7, 2011 at 1:09 PM, Aindril De aind...@gmail.com wrote:

 Sorry NOT USING TRIM


 On Wed, Dec 7, 2011 at 2:39 PM, Aindril De aind...@gmail.com wrote:

 NOTE:
 I am using the simple TRIM() function as the data you have sent
 contains multiple spaces in the trail.


 On Wed, Dec 7, 2011 at 2:35 PM, Aindril De aind...@gmail.com wrote:

 Dear Lakshman,

 You are not able to do the SUM as the data in the last column has
 leading and trailing spaces.
 You can use the add-on
 http://www.ablebits.com/excel-trim-spaces/index.php
 to quickly remove the spaces, if you regularly receive/generate such
 data.

 Cheers,
 Andy


 On Wed, Dec 7, 2011 at 1:43 PM, Lakshman Prasad 
 lakshman...@yahoo.comwrote:

  Dear All,
 Plz see the attach file. I can’t understand why I m unable to do sum.
 What is the problem in sheet or number? Help anybody?
 Regards
 LAKSHMAN

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum
 in signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




 --

 Warm Regards,
 Aindril De
 Ph: 9811300157




 --

 Warm Regards,
 Aindril De
 Ph: 9811300157




 --

 Warm Regards,
 Aindril De
 Ph: 9811300157

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


   --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data

Re: $$Excel-Macros$$ Formula Help

[rajan verma]

hi
please see the attached File..
Hope this will help

Rajan.

On Wed, Dec 7, 2011 at 2:00 PM, hemant hemantda...@yahoo.com wrote:

 Hi all

 I need help on the following in EXCEL 2007:

 Compare the values of sheet 1:column A with Values of Sheet2:column A

 If the CELL values in sheet1 column matches with Range of values in
 Sheet2 column.

 copy that CELL VALUE from sheet1 and paste it adjacent column (Column
 B) of sheet2. Or COLOUR that particular cell background.

 Thanks and Regards
 Hemant Dange


 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


conditionalFormatting.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Progress bar - urgent

[rajan verma]

see the attached File..


On Wed, Dec 7, 2011 at 12:34 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Dear Dharti Kumar,

 Please see attached doc to create Progress bar in Excel.

 -
 Thanks  regards,
 Noorain Ansari
  *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/


 On Wed, Dec 7, 2011 at 12:02 PM, Dhartikumar Sahu 
 dhartiku...@gmail.comwrote:


 Hi Experts

 Please help me to write macro in attached file.

 Note: I need progress bar while Update Links are progress.

 --

 *Regards,*

 *Dhartikumar Sahu*

 Sr.Database Manager - Institutional Equities

 * **IDBI Capital Markets Services Ltd*

 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21

 Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




 -

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


ProgresBar.xlsm
Description: Binary data

Re: $$Excel-Macros$$ How can click on HTML button using it's class.

[rajan verma]

Try this
For each Element in HDoc.getelementbyclass(abc)
element.click
next element

On Wed, Dec 7, 2011 at 2:34 PM, Mithlesh Sharma mtshar...@gmail.com wrote:

 Hi Friend,

   Can we click on HTML button using
 getelementbyclass(abc).click, if this is possible please let me know with
 example.


 Thanks
 Mithlesh Sharma

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Working in multiple workbooks

[rajan verma]

Hi Bajrang,
what error you getting if you dont open second file...

Rajan.

On 12/3/11, B Sharma sharma@gmail.com wrote:
 Dear Excel Experts...

 I have created two separate work book.
 1st one is the  database and 2nd one is the report / summary file

 now my query is that while checking the reports I dont want to open
 the database file ,, currently I have to open both file for working.

 Is there any easy way.

 2ndly please give some tips so that I can minimize the size of the
 workbook.

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --
 To post to this group, send email to excel-macros@googlegroups.com



-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Working in multiple workbooks

[rajan verma]

we need to open linked file in some cases like if we used sumif ,Countif..

Rajan.

On 12/5/11, Veer virbhardwaj...@gmail.com wrote:
 Dear B Sharma,

 if you dont want to open both files, u can merge all the worksheets of
 both workbooks in one workbook.

 or u can attach your files as example to make practical solution.

 THanks

 Veer


 On Dec 4, 4:14 am, B Sharma sharma@gmail.com wrote:
 Dear friends
 thanks for replyinng

 But I havrent got my solution

 On Dec 3, 11:19 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote:



  Dear B. Sharma,

  Read this article or use VBA Macro mentioned
  thereby:-http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html

  Thanks  regards,
  Noorain Ansari
   
  *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
  *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/

  On Sat, Dec 3, 2011 at 10:31 AM, B Sharma sharma@gmail.com wrote:
   Dear Excel Experts...

   I have created two separate work book.
   1st one is the  database and 2nd one is the report / summary file

   now my query is that while checking the reports I dont want to open
   the database file ,, currently I have to open both file for working.

   Is there any easy way.

   2ndly please give some tips so that I can minimize the size of the
   workbook.

   --
   FORUM RULES (934+ members already BANNED for violation)

   1) Use concise, accurate thread titles. Poor thread titles, like
   Please
   Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
   Advice
   will not get quick attention or may not be answered.

   2) Don't post a question in the thread of another member.

   3) Don't post questions regarding breaking or bypassing any security
   measure.

   4) Acknowledge the responses you receive, good or bad.

   5)  Cross-promotion of, or links to, forums competitive to this forum
   in
   signatures are prohibited.

   NOTE  : Don't ever post personal or confidential data in a workbook.
   Forum
   owners and members are not responsible for any loss.

   ---
   ---
   To post to this group, send email to excel-macros@googlegroups.com

  --- Hide quoted text -

 - Show quoted text -

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --
 To post to this group, send email to excel-macros@googlegroups.com



-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Comvert Excel/CSV to XML

[rajan verma]

Hi
Please try this :
Sub MakeXML()
Dim strPath As String
Dim rngUsed As Range
Dim rngRow  As Range
Dim wbknew  As Workbook
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = please Choose Folder to Save XML File
.Show
strPath = .SelectedItems(1)
End With
If strPath =  Then
MsgBox Exit
End If
Set rngUsed = ThisWorkbook.ActiveSheet.UsedRange
Application.ScreenUpdating = False
ThisWorkbook.SaveAs strPath  \  ThisWorkbook.Name, 46
For Each rngRow In rngUsed.Rows
rngRow.Copy
Set wbknew = Workbooks.Add(1)
wbknew.ActiveSheet.Paste
wbknew.SaveAs strPath  \  wbknew.Name, 46
wbknew.Close
Next
MsgBox Done
Application.ScreenUpdating = False
End Sub


On 12/6/11, Aindril De aind...@gmail.com wrote:
 Hi All,

 I have a dataset in Excel.
 I have to do the following:
 1) Convert the dataset to XML Format
 2) Create a different XML File for each row.

 Any help would be really appreciated.

 Cheers
 --

 Andy

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --
 To post to this group, send email to excel-macros@googlegroups.com



-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Auto schedule for execution of macro

[rajan verma]

yes we need to open that file and Run that macro to create schedule
for any other macro..

Write that code on workbook_open events . so that when we open that
workbook.. its automatically triggered and create Schedule .

Rajan


On 12/5/11, Gangaram. sgang...@gmail.com wrote:
 I have tried this using the following steps

 1. Calling the function in workbook.open event
 2. Create a batch file which will open the excel file

 Sample Batch file:

 cd c:\Program Files\Microsoft Office\Office12\

 EXCEL.EXE  c:\Test.xlsm

 3. Using windows scheduler you can create a new schedule job and
 mention the frequency and time.

 you can find the windows schedular in the following shortcut (Windows
 XP) C:\Documents and Settings\All Users\Start Menu\Programs\Accessories
 \System Tools

 Now you are ready the job wlll run with out manual intervention. only
 thing you need to do is you should keep the system up


 On Dec 5, 1:25 am, Maries talk2mar...@gmail.com wrote:
 Hi Rekha,

 If you create a *shortcut* of your excel file in startup folder, then it
 will open automatically on window startup.

 Find the startup folder in below path:
 *Windows7 ==
 **C:\Users\(User-Name)\AppData\Roaming\Microsoft\Windows\Start
 Menu\Programs\Startup*
 *Windows Xp == C:\Documents and Settings\All Users\Start
 Menu\Programs\Startup

 *The file should have a *Application.onTime* Macro (As Rajan shown in
 code)
 for call your *Target Macro* as per scheduled time.

 Hence, We can avoid a manual intervention with help of windows startup
 option.

 I hope this will clarify clear.

 Regards,

 MARIES.
 +971559828492.
 *

 *







 On Sun, Dec 4, 2011 at 7:57 PM, rekha siri rekha.siri2...@gmail.com
 wrote:
  hi Rajan /sam,

  thanks for the reply please advise will it execute without opening the
  macro or we need to open the macro sheet and then  fix the reminder.

  Thanks,
  Rekha

  On Sun, Dec 4, 2011 at 7:00 PM, rajan verma
  rajanverma1...@gmail.comwrote:

  Sub Test()
  Application.onTime now+timevalue(00:30:00),ProcedureName
  end sub
  it means after 30 minute from now procedure ProcedureName will
  Execute.
  On Sun, Dec 4, 2011 at 5:39 PM, Sam Mathai Chacko
  samde...@gmail.comwrote:

  Search the net for Application.OnTime

  Regards,

  Sam Mathai Chacko

  On Sun, Dec 4, 2011 at 3:25 PM, rekha siri
  rekha.siri2...@gmail.comwrote:

  hi Experts,

  Please advise is there any option to schedule for particular time to
  macro for execution on its on own without manual intervention.

  if so please advise in this concern.

  Thanks,
  Rekha

  --
  FORUM RULES (934+ members already BANNED for violation)

  1) Use concise, accurate thread titles. Poor thread titles, like
  Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
  Advice
  will not get quick attention or may not be answered.

  2) Don't post a question in the thread of another member.

  3) Don't post questions regarding breaking or bypassing any security
  measure.

  4) Acknowledge the responses you receive, good or bad.

  5) Cross-promotion of, or links to, forums competitive to this forum
  in
  signatures are prohibited.

  NOTE : Don't ever post personal or confidential data in a workbook.
  Forum owners and members are not responsible for any loss.

  --
  To post to this group, send email toexcel-mac...@googlegroups.com

  --
  Sam Mathai Chacko

  --
  FORUM RULES (934+ members already BANNED for violation)

  1) Use concise, accurate thread titles. Poor thread titles, like
  Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
  Advice
  will not get quick attention or may not be answered.

  2) Don't post a question in the thread of another member.

  3) Don't post questions regarding breaking or bypassing any security
  measure.

  4) Acknowledge the responses you receive, good or bad.

  5) Cross-promotion of, or links to, forums competitive to this forum
  in
  signatures are prohibited.

  NOTE : Don't ever post personal or confidential data in a workbook.
  Forum owners and members are not responsible for any loss.

  --
  To post to this group, send email toexcel-mac...@googlegroups.com

  --
  Regards
  Rajan verma
  +91 9158998701

  --
  FORUM RULES (934+ members already BANNED for violation)

  1) Use concise, accurate thread titles. Poor thread titles, like Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
  will not get quick attention or may not be answered.

  2) Don't post a question in the thread of another member.

  3) Don't post questions regarding breaking or bypassing any security
  measure.

  4) Acknowledge the responses you receive, good or bad.

  5) Cross-promotion of, or links to, forums competitive to this forum in
  signatures are prohibited.

  NOTE : Don't

Re: $$Excel-Macros$$ update link automatically in excel sheet

[rajan verma]

 or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --
 To post to this group, send email to excel-macros@googlegroups.com



-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ How to close many files at a time

[rajan verma]

On 12/3/11, Amit Desai (MERU) amit.de...@merucabs.com wrote:
 Hi All,

 In case if i want to close many excel files ( not all) or emails all at a
 time (in stead of selecting one at a time - want to select many..), how can
 we do that?

 Regards,
 Amit Desai

 
 Disclaimer: This message and its attachments contain confidential
 information and may also contain legally privileged information. This
 message is intended solely for the named addressee. If you are not the
 addressee indicated in this message (or authorized to receive for
 addressee), you may not copy or deliver any part of this message or its
 attachments to anyone or use any part of this message or its attachments.
 Rather, you should permanently delete this message and its attachments (and
 all copies) from your system and kindly notify the sender by reply e-mail.
 Any content of this message and its attachments that does not relate to the
 official business of Meru Cab Company Pvt. Ltd. must be taken not to have
 been sent or endorsed by any of them. Email communications are not private
 and no warranty is made that e-mail communications are timely, secure or
 free from computer virus or other defect.

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --
 To post to this group, send email to excel-macros@googlegroups.com



-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


CloseMultipleFile.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Auto schedule for execution of macro

[rajan verma]

Sub Test()
Application.onTime now+timevalue(00:30:00),ProcedureName
end sub
it means after 30 minute from now procedure ProcedureName will Execute.
On Sun, Dec 4, 2011 at 5:39 PM, Sam Mathai Chacko samde...@gmail.comwrote:

 Search the net for Application.OnTime

 Regards,

 Sam Mathai Chacko


 On Sun, Dec 4, 2011 at 3:25 PM, rekha siri rekha.siri2...@gmail.comwrote:

 hi Experts,

 Please advise is there any option to schedule for particular time to
 macro for execution on its on own without manual intervention.

 if so please advise in this concern.

 Thanks,
 Rekha

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




 --
 Sam Mathai Chacko

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Data validation not working properly

[rajan verma]

Remove check from Ignore Blanks in data validatoin

On Sat, Dec 3, 2011 at 7:20 PM, dguillett1 dguille...@gmail.com wrote:

 Try removing blank cells in your defined name list or ' ' '



 Don Guillett
 SalesAid Software
 dguille...@gmail.com
 -Original Message- From: B Sharma
 Sent: Friday, December 02, 2011 10:52 PM
 To: MS EXCEL AND VBA MACROS
 Cc: rajanverma1...@gmail.com
 Subject: $$Excel-Macros$$ Data validation not working properly


 Dear Excel Experts.

 I have created a drop down list using data validation and the source
 of the list is a dynamic range created at another sheet.

 I have checked Show error alert after invalid data entered

 Its working fine and showing the source list in the drop down list but
 it also accepts any other enteries made which are not part of that
 list.

 Please help me why its happening..

 Thanks  Regards
 BS

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --**--**
 --**
 To post to this group, send email to excel-macros@googlegroups.com
 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.
 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --**--**
 --**
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ fso

[rajan verma]

By FileSystemObject we can do operation with File and folder..Here is code
for that..

Sub GetAllFilesInAFolder()
Dim fso As New Scripting.FileSystemObject
Dim flFIle As File
Dim fdFOlder As Folder
 Set fdFOlder = fso.GetFolder(C:\Documents and Settings\Cyber
Junction\My Documents)
 For Each flFIle In fdFOlder.Files
'Do you all OPeration with FIle here
 Next

set fso=nothing
set flFIle =nothing
set fdFOlder =nothing

End Sub


On Sat, Dec 3, 2011 at 6:25 PM, Sam Mathai Chacko samde...@gmail.comwrote:

 Rakesh,

 Application.FileSearch has been discontinued from Excel 2007 for reasons I
 am still not sure why. You can find an alternative method here.

 http://www.ozgrid.com/forum/showthread.php?t=147929

 Regards,
 Sam Mathai Chacko


 On Sat, Dec 3, 2011 at 6:20 PM, Rakesh Joshi rakesh.ri...@gmail.comwrote:

 Hi Ashish,

 i need to open all files in a folder and run the macro regarding macro i
 can take care but opening all files in folder i am getting trouble
 application .filesearch is not working 2010 coudl you please let me know
 how to do that.

 --
 Rakesh Joshi

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




 --
 Sam Mathai Chacko

  --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ What does -- suggest in formula.

[rajan verma]

As it convert TRUE/False into 1/0  ..we can debug formula error easily..

On Sat, Dec 3, 2011 at 4:02 PM, Sam Mathai Chacko samde...@gmail.comwrote:

 Sandeep,

 The -- is used as an unary operator to convert a boolean value ie,
 TRUE/FALSE in to 1/0. Sumproduct for example does not evaluate non-numeric
 values that results in a formula like the boolean results in the array
 equation A1:A10=Sandeep.

 So to negate this, we use unary operator -- with TRUE or FALSE to give 1
 or 0

 We can also use ++

 In fact you can also use a multiplier or a divisor of 1

 In case you'd like more information, look up in google. Here's something
 from an Excel MVP

 http://www.mcgimpsey.com/excel/formulae/doubleneg.html

 Regards,

 Sam Mathai Chacko

 On Sat, Dec 3, 2011 at 10:50 AM, chhajersand...@gmail.com wrote:

 Dear Excel gurus,

 I have noticed that many time you all use -- in a formula. Why is it been
 used and when it should be used?

 Sandeep Kumar Chhajer.
 Sent on my BlackBerry® from Vodafone

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




 --
 Sam Mathai Chacko

  --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ recording macros

[rajan verma]

I think macro recording is not a good idea to find duplicates ... because
most of time  sheet Name will change.. Data Range at worksheet will
change..

You can write a macro for this purpose..by using conditional Formatting..

On Sat, Dec 3, 2011 at 9:32 AM, vijayajith VA vijayajith...@gmail.comwrote:

 Hi

 I have two workbooks.sheet1 and sheet2. I want to find duplicates data
 from sheet1 to sheet2.Is this possible to record a macro.for this?

 Thanks

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Correction in Formula

[rajan verma]

you can use Countifs like this.. if you want to compare value you need to
put the operator (  ) in  inverted COmmas..

=countifs(B1:B17,10,A1:A17,10)

On Sat, Dec 3, 2011 at 4:49 AM, B.N.Chethan Kumar chetankumar1...@gmail.com
 wrote:

 Please find the information as requested


 On Sat, Dec 3, 2011 at 1:25 AM, Aamir Shahzad aamirshahza...@gmail.comwrote:

 Dear Group,

 I am using Countifs function how I give the second criteria e.g. I want
 9 it's mean only pick the buckets of 10,11  12. See the attached file
 plz.

 Regards,

 Aamir Shahzad

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




 --
 B.N Chetan kumar

  --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Indirect Function

[rajan verma]

if we need to know how many Rows Contains data we can use  indirect
function like this :

=ROWS(INDIRECT(A1:ACOUNTA(A:A)))

On Thu, Dec 1, 2011 at 11:19 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:

 thanks Noorain / Chethan Kumar.

 Regards,

 Aamir Shahzad

 On Thu, Dec 1, 2011 at 9:03 AM, Dhartikumar Sahu dhartiku...@gmail.comwrote:

 hi chethan

 can u explain how u use getphoto in Indirect example 3.

 Thanks  regards
 Dhartikumar Sahu


 On Thu, Dec 1, 2011 at 3:07 AM, B.N.Chethan Kumar 
 chetankumar1...@gmail.com wrote:

 Hope these help.


 On Wed, Nov 30, 2011 at 11:47 PM, Aamir Shahzad 
 aamirshahza...@gmail.com wrote:

 Dear Group,

 Please provide the Indirect Function samples how is it working  when
 we use? Sample files will appreciate.

 Regards,

 Aamir Shahzad

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




 --
 B.N Chetan kumar

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




 --

 Regards,

 Aamir Shahzad

  --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook

Re: $$Excel-Macros$$ About Marcros in 2007

[rajan verma]

hi
its a strange problem but hope it will help you ..

http://www.mrexcel.com/forum/showthread.php?t=71323

On Thu, Dec 1, 2011 at 6:04 PM, Aivi aivran...@gmail.com wrote:

 Hi,Friends

 Any body give the refernce of MACRO IN EXECEL 2007, How can create and how
 do work the with  macros
 Pls give me some example and reference













 Aivi K

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ About Marcros in 2007

[rajan verma]

 please ignore that post.,
You can download this book..
http://www.rencross.co.uk/ebookshelf/Microsoft/Visual%20Basic/Office/VBA/Excel%202007%20Power%20Programming%20With%20VBA.pdf

On Sat, Dec 3, 2011 at 8:43 PM, rajan verma rajanverma1...@gmail.comwrote:

 hi
 its a strange problem but hope it will help you ..

 http://www.mrexcel.com/forum/showthread.php?t=71323

 On Thu, Dec 1, 2011 at 6:04 PM, Aivi aivran...@gmail.com wrote:

 Hi,Friends

 Any body give the refernce of MACRO IN EXECEL 2007, How can create and
 how do work the with  macros
 Pls give me some example and reference













 Aivi K

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




 --
 Regards
 Rajan verma
 +91 9158998701




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ ActiveX Setting in Excel 2003

[rajan verma]

Hope it will help
http://www.mrexcel.com/forum/showthread.php?t=71323

On Sat, Dec 3, 2011 at 8:16 PM, Secret Shot secrets...@gmail.com wrote:

 Hay Guy,,

 Can any one please Help me in this, this is really critical..

 Regards
 Pankaj k Pandey


 On Sat, Dec 3, 2011 at 4:26 AM, Secret Shot secrets...@gmail.com wrote:

 Dear Experts,

 Can anyone please tell me that how to Enable Activex Setting in Excel
 2003. I know how to do this in 2007.
 Excel OptionTrust Center Trust Center SettingActiveX Setting

 But don't know hot to st thins in Excel 2003, Please help me
 I will appreciate quick help
 Please

 --
 Pankaj Pandey
 Bhopal

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




 --
 Pankaj Pandey
 Bhopal

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Most Helpful Member Nov'11 - Sam Mathai Chacko

[rajan verma]

Congrats Boss.

On 12/2/11, Ayush Jain jainayus...@gmail.com wrote:
  Hello Everyone,

 Sam Mathai Chacko has been recognised as 'Most Helpful Member' for the
 month of Nov'11
 He has posted 129 posts (13% of total posts) in Nov 2011 and helped many
 people through his expertise. He has been consistent contributor to this
 excel forum and has acheived this recognition second time.

 *About Sam Mathai Chacko :*

  [image: SamMathaiChacko03.JPG]

 Sam is Kerala born malayalee and has been in Gurgaon, since 2004 and living
 happily with his family. He has been working in WNS, Gurgaon as a Team
 Manager and leading a big team of 23 MS-office specialists.
 Sam is passionate about office applications, and wanted to share and help
 people around on same. He regularly spend 2 hours online daily to solve
 people queries on different forums. Apart from work, he is fond of computer
 games and like to spend time with his kid.

 *Sam, Many thanks for all your fantastic support to group. Cheers!!*
 *Thanks to Don Guillett( Runner -up ), Noorain, Ashish and other folks for
 helping excel enthusiasts voluntarily !! Keep it up !!

 *Keep posting.

 Regards
 Ayush Jain
 Group Manager
 Microsoft Most Valuable Professional

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --
 To post to this group, send email to excel-macros@googlegroups.com



-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

[rajan verma]

 the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Help me with a macro

[rajan verma]

Hi
Please see the attached file.. Pivot table can be used for this ..

Regards
Rajan

On Sat, Nov 26, 2011 at 8:23 PM, son nguyen sonnguye...@gmail.com wrote:

 Dear all,


 I have problem of calculating sheet.Detail as sheet attached.
 I want to have a macro to sum value within qty, and downtime column then
 delete products are duplicated within each machine.

 I look foward to hear your help asap


 Best Regards
 Son

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


example(1).xlsm
Description: Binary data

Re: $$Excel-Macros$$ regarding date changing method

[rajan verma]

HI,
You can change Cell Format as you required like dd.mm or mm.dd

On Tue, Nov 15, 2011 at 1:40 PM, Sanjib Chatterjee 
chatterjee.kolk...@gmail.com wrote:


 Dear Members,

 In excel 2003 I want to put the value in the cell (A1) as 15.11.  But
 while changing(i.e. press enter or tab)
  the cell I want to  convert the figure as 15.11.2011 and so on.

 Thanking you in Advance

 Regards,

 Sanjib





 --
 -

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Modify code to lock multiple sheets in a spreadsheet.

[rajan verma]

You can try Allow User To Edit Range Option.. Hope it will help..

On Fri, Nov 11, 2011 at 2:01 AM, dguillett1 dguille...@gmail.com wrote:

 I should have been clearer. I meant to suggest they each have their own
 FILE and then you have a macro to combine. If all in the same folder its
 fairly easy to combine the files, if desired.




 Don Guillett
 SalesAid Software
 dguille...@gmail.com
 -Original Message- From: Dave
 Sent: Thursday, November 10, 2011 2:18 PM

 To: MS EXCEL AND VBA MACROS
 Subject: Re: $$Excel-Macros$$ Modify code to lock multiple sheets in a
 spreadsheet.


 That what they have now ...without the macro to combine them and they
 have to roll it up by hand.
 Can I use the Macro recorder in Excel to do this task?

 On Nov 10, 2:15 pm, dguillett1 dguille...@gmail.com wrote:

 Why not give each their own sheet and then you combine with a macro.

 Don Guillett
 SalesAid Software
 dguille...@gmail.com



 -Original Message-
 From: Dave
 Sent: Thursday, November 10, 2011 2:09 PM
 To: MS EXCEL AND VBA MACROS
 Subject: $$Excel-Macros$$ Modify code to lock multiple sheets in a
 spreadsheet.

 Hi,

 I have an Excel 2010 Workbook with 17 Worksheets, Sheet1... Sheet17. I
 have this workbook shared on the network. Employees open this workbook
 and they enter their daily work log into it individual work sheets.
 The problem I am having is that No one knows who did it syndrome
 where either accidently or intentionally employees are subtracting the
 work done by other employees   or deleting data.

 So I am looking for a solution where I can restrict each employee to
 their own worksheet. All suggestions are welcome.

 I came across the following code this works great  for sheet1 but I
 need it to be modified for 17 sheets. As I am not a programmer I have
 not been able to implement it across my 17 sheets. Can you guys fix it
 so that I can use it across my 17 sheets.

 This is the code:  
 http://www.ozgrid.com/VBA/**stop-worksheet-viewing.htmhttp://www.ozgrid.com/VBA/stop-worksheet-viewing.htm

 thanks to all

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --**--**
 ---­--**-
 To post to this group, send email to excel-macros@googlegroups.com- Hide
 quoted text -

 - Show quoted text -


 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --**--**
 --**
 To post to this group, send email to excel-macros@googlegroups.com
 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.
 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --**--**
 --**
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice

Re: $$Excel-Macros$$ Spell Check and Highlighting Individual Words

[rajan verma]

Hi
Try this .. Hope it will Resolve Your Query

*Public MyTest As Boolean
Public myWord As String*
*Sub GetText()*
*On Error Resume Next*
*Dim ws As Worksheet*
*Dim st As String*
*Dim arr() As String*
*Dim cell As Range*
**
*Set ws = ActiveSheet*
*Sheets(WrongWord).Delete*
*Sheets.Add.Name = WrongWord*
*ws.Activate*
*st = *
**
**
*For Each cell In ActiveSheet.UsedRange*
*st = st cell.Value*
*Next*
**
*arr = Split(st,  )*
*For i = LBound(arr) To UBound(arr)*
*myWord = arr(i)*
*Call mySpell*
*If MyTest = False Then
Sheets(WrongWord).Range(A 
Sheets(WrongWord).Range(A2).End(xlUp).Row + 1).Value = myWord*
*MyTest = False*
*Next*
*Sheets(WrongWord).Activate*
*MsgBox Total  
WorksheetFunction.CountA(ActiveSheet.Cells)Wrong Word Found in Data ,
vbInformation*
*End Sub*
*Sub mySpell()*
*MyTest = Application.CheckSpelling(myWord)*
*
*
*End Sub*
http://excelpoweruser.blogspot.com/2011/07/get-wrong-keyword-on-another-sheets.html

On Thu, Oct 13, 2011 at 4:41 PM, Greg2011 gdbar...@googlemail.com wrote:

 Hi

 I have an Excel sheet with VBA which is designed to compare two boxes
 of text/copy and highlight any differences. The existing code is very
 good although, it does not currently highlight individual words (it
 only changes the box color to red to suggest there is an error).

 Here is the existing code (the spreadsheet can also be shared if that
 would be useful?):

'check the spelling of the selected text
Select Case bcheck
Case True
If SpellingIsCorrect(sCopy) = False Then
If .Range(Q  plRow).Value =  Then
.Range(Q  plRow).Value = Check
 ASFspelling
Else
.Range(Q  plRow).Value = .Range(Q
 plRow).Value   | Check ASF spelling
End If
End If
If SpellingIsCorrect(sEmail) = False Then
If .Range(Q  plRow).Value =  Then
.Range(Q  plRow).Value = Check email
 spelling
Else
.Range(Q  plRow).Value = .Range(Q
 plRow).Value   | Check email spelling
End If
.Range(J  plRow).Select 'background = red
 asthis is an error
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorAccent2
.TintAndShade = 0.399945066682943
.PatternTintAndShade = 0
End With
End If
Case Else
'do nothing as we do not want to check the spelling in
 anything but the above sections
End Select

 Is it possible to adapt the code so that individual (incorrectly
 spelt) words are highlighted (rather than the whole block)?

 Any help much appreciated,

 Kind regards

 Greg

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Average

[rajan verma]

Hi pramod.
Put this in E2
=(C3/B3)/D3

:)



On Thu, Oct 13, 2011 at 4:15 PM, Pramod Kumar
kumar.pramod03i...@gmail.comwrote:

 Dear Experts,
 Please find attached data sheet  I want per day per site average.


 --
 Regards,
 Pramod Kumar
 Technocare Solution(TCS)
 Rudrapur
 +91 9927033573
 E-Mail:-kumar.pramod03i...@gmail.com




 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: Fw: $$Excel-Macros$$ Help required

[rajan verma]

Try this :
its not a Good Macro but can Solve your Query :
Sub bifurCateData()

Dim rngHeading  As Range
Dim RngData As Range
Dim rngCell As Range
Dim strCountryname  As String
Dim intLastrow  As Integer
With Range(A1)
Set RngData = Intersect(.CurrentRegion, .CurrentRegion.Offset(1))
End With
Set rngHeading = Range(A1).Resize(1, Range(A1).End(xlToRight).Column
+ 1)
RngData.Sort Key1:=RngData.Cells(, RngData.Columns.Count)

For IntI = ActiveSheet.UsedRange.Rows.Count To 3 Step -1
If Range(H  IntI).Value  Range(H  IntI - 1).Value Then
Range(H  IntI).Resize(3, 1).EntireRow.Insert
End If
Next
intLastrow = ActiveSheet.UsedRange.Rows.Count
Range(A1).Activate
lable1:
ActiveCell.End(xlDown).Cells.Offset(2, 0).Select
If ActiveCell.Row = intLastrow Then
Range(A1).Select
Exit Sub
End If
ActiveCell.Value = ActiveCell.Offset(2, 7).Value
ActiveCell.Offset(1, 0).Resize(1, 8).Value = rngHeading.Value
GoTo lable1:
End Sub


On Thu, Oct 13, 2011 at 4:21 PM, Mr Excellent suryaprasad...@gmail.comwrote:

 Hi Group,

 Please help

 Thanks
 Prasad.

   -- Forwarded message --
 From: suryaprasad...@gmail.com
 Date: Thu, Oct 13, 2011 at 10:43 AM
 Subject: Fw: $$Excel-Macros$$ Help required
 To: excel-macros@googlegroups.com


 **Hi Guys can anyone help me on this please

 Thanks
 Prasad

 Sent from BlackBerry® on Airtel
 --
 *From: *Mr Excellent suryaprasad...@gmail.com
 *Sender: *excel-macros@googlegroups.com
 *Date: *Thu, 13 Oct 2011 04:52:12 +0530
 *To: *excel-macros@googlegroups.com
 *ReplyTo: *excel-macros@googlegroups.com
 *Subject: *$$Excel-Macros$$ Help required

 Hi Group,

 Need a small help, i have a code which runs on the data and seggregates the
 details as per the Country, but additional to that i require the Country
 name should come on the top of each rows which are divided by country in the
 first column and the heading should be applicable to all the seggregated
 rows as per the country and should be bold and underlined.

 The example data is given in the first TAB Tes
 My Code example data is given in the second TAB My Code
 Actual required data is given in third TAB  Actual Required

 Please help

 Thanks
 Prasad.


 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ file browser

[rajan verma]

Hi,
You can use Application.findFile(FileFilter) method.



On Wed, Oct 12, 2011 at 3:56 PM, airen airen1...@gmail.com wrote:

 Hi experts,
 How to open a file from user via browse in VBA
 Thanks
 Akhilesh

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Cannot display properties of ActiveX checkbox that has been added through VBA

[rajan verma]

Dont Use Shapes , use this Code

ActiveSheet.OLEObjects.Add(classtype:=Forms.Checkbox.1)


On Wed, Oct 12, 2011 at 6:26 PM, Stuart Redmann dertop...@web.de wrote:

 Hello newsgroup,

 I tried the following code to create an ActiveX checkbox under Excel:

 - Create new workbook.
 - Add following code to worksheet 1

 Sub test()
  Me.Shapes.AddOLEObject Forms.CheckBox.1, , False, False, , , ,
 100, 100, 100, 100
 End Sub

 - Execute code

 Now I have got a worksheet with a single checkbox. If I try to view
 the properties of this checkbox, I enable the design mode of the
 Toolbox toolbar and make a right-click on the checkbox. The options
 that are available are
 Cut, Copy, Paste, separator, Checkbox-Object, Show graphics
 symbol bar, separator, Grouping, Order, separator, Assign
 Macro (greyed out) and Format object (these are my translation of
 the German version of Excel, so these menu entries may be different in
 the English version).

 I miss the entry Properties. However, if I add a checkbox by hand, I
 can display the properties of this checkbox through the context menu.
 Once the property window is up, I can select the VBA added checkbox
 and can edit its properties without problems.

 I use Excel 2003 (11.8231.8221) SP3.

 Can anybody re-produce this behaviour?
 Is this a bug?
 If it is a bug, does it go away under Excel 2003+x, x0?

 Thanks in advance,
 Stuart


 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Pasting a button onto multiple sheets

[rajan verma]

I Create a  macro to an Index Sheet..
Hope it will be Usable

Sub MakeComponentinRunTImeOnSpreadSheet()
On Error Resume Next
Dim cb As OLEObject
n = 5
For i = 1 To 10
 Set cb = ActiveSheet.OLEObjects.Add(classtype:=Forms.Checkbox.1)
With cb
.Top = n
.Object.Caption = Do you want to Select Range
.LinkedCell = Active.Offset(0, 5).Address
.Object.Value = False
.Visible = True
End With
ActiveCell.Offset(1, 0).Activate
Set cb = Nothing
n = n + 20
Next
End Sub
Sub MakeMyIndex()

Dim intICounter As Integer
Dim intTotalSheet   As Integer
Dim wksIndexAs Worksheet
Dim shButtonAs Shape

Set wksIndex = Worksheets.Add
wksIndex.Name = Index
intTotalSheet = ThisWorkbook.Worksheets.Count
For intICounter = 1 To intTotalSheet
If Worksheets(intICounter).Name  wksIndex.Name Then
Set shButton = wksIndex.Shapes.AddShape(msoShapeRectangle,
wksIndex.Cells(intICounter, 3).Left, wksIndex.Cells(intICounter, 3).Top,
wksIndex.Cells(intICounter, 3).Width, wksIndex.Cells(intICounter, 3).Height)
wksIndex.Hyperlinks.Add shButton, , ' 
Worksheets(intICounter).Name  '!A1, Click Me,
Worksheets(intICounter).Name
shButton.TextFrame.Characters.Text =
Worksheets(intICounter).Name
Set sh = Nothing
End If
Next
wksIndex.Cells(, 3).EntireColumn.ColumnWidth = 16
For intICounter = 1 To intTotalSheet
If Worksheets(intICounter).Name  wksIndex.Name Then
Set shButton =
Worksheets(intICounter).Shapes.AddShape(msoShapeRectangle,
Worksheets(intICounter).Range(B3).Left,
Worksheets(intICounter).Range(B3).Top, _
Worksheets(intICounter).Range(B3).Width,
Worksheets(intICounter).Range(B3).Height)
 Worksheets(intICounter).Columns(3).ColumnWidth = 16
wksIndex.Hyperlinks.Add shButton, , '  wksIndex.Name 
'!A1, Click Me, Index
shButton.TextFrame.Characters.Text = Index
Set sh = Nothing
End If
Next
End Sub



On Wed, Oct 12, 2011 at 9:03 PM, Divaker Pandey divake...@gmail.com wrote:

 it is so easy, if you use hyperlink instead of button

 Divaker



 On Wed, Oct 12, 2011 at 5:15 PM, Eddie eddiejame...@googlemail.comwrote:

 Hi,

 I have a workbook with around 100 worksheets. The first sheet acts as
 a summary/introductory or front end and has links to other sub-
 sheets. In the first sub-sheet I've created a button containing a
 macro that returns you to the introduction sheet. What I'd like to do
 is copy this button onto each of the sub-sheets, however Excel doesnt
 allow me to paste into multiple sheets. Is there anyway of replicating
 this button in multiple sheets without having to do this manually for
 each sheet?

 Any help very much appreciated.

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Pasting a button onto multiple sheets

[rajan verma]

please Ignore previouse Mail


Sub MakeMyIndex()

Dim intICounter As Integer
Dim intTotalSheet   As Integer
Dim wksIndexAs Worksheet
Dim shButtonAs Shape

Set wksIndex = Worksheets.Add
wksIndex.Name = Index
intTotalSheet = ThisWorkbook.Worksheets.Count
For intICounter = 1 To intTotalSheet
If Worksheets(intICounter).Name  wksIndex.Name Then
Set shButton = wksIndex.Shapes.AddShape(msoShapeRectangle,
wksIndex.Cells(intICounter, 3).Left, wksIndex.Cells(intICounter, 3).Top,
wksIndex.Cells(intICounter, 3).Width, wksIndex.Cells(intICounter, 3).Height)
wksIndex.Hyperlinks.Add shButton, , ' 
Worksheets(intICounter).Name  '!A1, Click Me,
Worksheets(intICounter).Name
shButton.TextFrame.Characters.Text =
Worksheets(intICounter).Name
Set sh = Nothing
End If
Next
wksIndex.Cells(, 3).EntireColumn.ColumnWidth = 16
For intICounter = 1 To intTotalSheet
If Worksheets(intICounter).Name  wksIndex.Name Then
Set shButton =
Worksheets(intICounter).Shapes.AddShape(msoShapeRectangle,
Worksheets(intICounter).Range(B3).Left,
Worksheets(intICounter).Range(B3).Top, _
Worksheets(intICounter).Range(B3).Width,
Worksheets(intICounter).Range(B3).Height)
 Worksheets(intICounter).Columns(3).ColumnWidth = 16
wksIndex.Hyperlinks.Add shButton, , '  wksIndex.Name 
'!A1, Click Me, Index
shButton.TextFrame.Characters.Text = Index
Set sh = Nothing
End If
Next
End Sub



On Wed, Oct 12, 2011 at 9:26 PM, rajan verma rajanverma1...@gmail.comwrote:

  I Create a  macro to an Index Sheet..
 Hope it will be Usable

 Sub MakeComponentinRunTImeOnSpreadSheet()
 On Error Resume Next
 Dim cb As OLEObject
 n = 5
 For i = 1 To 10
  Set cb = ActiveSheet.OLEObjects.Add(classtype:=Forms.Checkbox.1)
 With cb
 .Top = n
 .Object.Caption = Do you want to Select Range
 .LinkedCell = Active.Offset(0, 5).Address
 .Object.Value = False
 .Visible = True
 End With
 ActiveCell.Offset(1, 0).Activate
 Set cb = Nothing
 n = n + 20
 Next
 End Sub
 Sub MakeMyIndex()

 Dim intICounter As Integer
 Dim intTotalSheet   As Integer
 Dim wksIndexAs Worksheet
 Dim shButtonAs Shape

 Set wksIndex = Worksheets.Add
 wksIndex.Name = Index
 intTotalSheet = ThisWorkbook.Worksheets.Count
 For intICounter = 1 To intTotalSheet
 If Worksheets(intICounter).Name  wksIndex.Name Then
 Set shButton = wksIndex.Shapes.AddShape(msoShapeRectangle,
 wksIndex.Cells(intICounter, 3).Left, wksIndex.Cells(intICounter, 3).Top,
 wksIndex.Cells(intICounter, 3).Width, wksIndex.Cells(intICounter, 3).Height)
 wksIndex.Hyperlinks.Add shButton, , ' 
 Worksheets(intICounter).Name  '!A1, Click Me,
 Worksheets(intICounter).Name
 shButton.TextFrame.Characters.Text =
 Worksheets(intICounter).Name
 Set sh = Nothing
 End If
 Next
 wksIndex.Cells(, 3).EntireColumn.ColumnWidth = 16
 For intICounter = 1 To intTotalSheet
 If Worksheets(intICounter).Name  wksIndex.Name Then
 Set shButton =
 Worksheets(intICounter).Shapes.AddShape(msoShapeRectangle,
 Worksheets(intICounter).Range(B3).Left,
 Worksheets(intICounter).Range(B3).Top, _
 Worksheets(intICounter).Range(B3).Width,
 Worksheets(intICounter).Range(B3).Height)
  Worksheets(intICounter).Columns(3).ColumnWidth = 16
 wksIndex.Hyperlinks.Add shButton, , '  wksIndex.Name 
 '!A1, Click Me, Index
 shButton.TextFrame.Characters.Text = Index
 Set sh = Nothing
 End If
 Next
 End Sub



 On Wed, Oct 12, 2011 at 9:03 PM, Divaker Pandey divake...@gmail.comwrote:

 it is so easy, if you use hyperlink instead of button

 Divaker



 On Wed, Oct 12, 2011 at 5:15 PM, Eddie eddiejame...@googlemail.comwrote:

 Hi,

 I have a workbook with around 100 worksheets. The first sheet acts as
 a summary/introductory or front end and has links to other sub-
 sheets. In the first sub-sheet I've created a button containing a
 macro that returns you to the introduction sheet. What I'd like to do
 is copy this button onto each of the sub-sheets, however Excel doesnt
 allow me to paste into multiple sheets. Is there anyway of replicating
 this button in multiple sheets without having to do this manually for
 each sheet?

 Any help very much appreciated.

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http

Re: $$Excel-Macros$$ Cannot display properties of ActiveX checkbox that has been added through VBA

[rajan verma]

if you want to see the Properties .. you can select  Property Option from
Developer Tab in Control Menu

On Wed, Oct 12, 2011 at 8:48 PM, rajan verma rajanverma1...@gmail.comwrote:

  Dont Use Shapes , use this Code

 ActiveSheet.OLEObjects.Add(classtype:=Forms.Checkbox.1)


   On Wed, Oct 12, 2011 at 6:26 PM, Stuart Redmann dertop...@web.dewrote:

 Hello newsgroup,

 I tried the following code to create an ActiveX checkbox under Excel:

 - Create new workbook.
 - Add following code to worksheet 1

 Sub test()
  Me.Shapes.AddOLEObject Forms.CheckBox.1, , False, False, , , ,
 100, 100, 100, 100
 End Sub

 - Execute code

 Now I have got a worksheet with a single checkbox. If I try to view
 the properties of this checkbox, I enable the design mode of the
 Toolbox toolbar and make a right-click on the checkbox. The options
 that are available are
 Cut, Copy, Paste, separator, Checkbox-Object, Show graphics
 symbol bar, separator, Grouping, Order, separator, Assign
 Macro (greyed out) and Format object (these are my translation of
 the German version of Excel, so these menu entries may be different in
 the English version).

 I miss the entry Properties. However, if I add a checkbox by hand, I
 can display the properties of this checkbox through the context menu.
 Once the property window is up, I can select the VBA added checkbox
 and can edit its properties without problems.

 I use Excel 2003 (11.8231.8221) SP3.

 Can anybody re-produce this behaviour?
 Is this a bug?
 If it is a bug, does it go away under Excel 2003+x, x0?

 Thanks in advance,
 Stuart


 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 Regards
 Rajan verma
 +91 9158998701




-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Dynamic chart range

[rajan verma]

You can use Offset Function to Create Dynamic Name Range and can use this
Range as Chart Data Source

=offset($A$2,,,Counta($A:$A),counta(ROw(2))

Create a New Name Range and put this Function there ..

On Thu, Oct 13, 2011 at 5:32 AM, Atul atul_pate...@yahoo.com wrote:

 Hi All,
 I want to make chart  range dynamic  For example, range A1:g1
 represents series for the first week and I want to extend the range
 for the second week means I want to change the range to A1:N1. Please
 help me to make it dynamic
 Thanks
 Atul

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$

[rajan verma]

Hi dilip,
How are you?
I dont have any software for this ..  I used Formula for recover the
Contents of sheets by Qualifying the Full address of Cell..

='workbookPath\WorkbookName[sheetName]'!CellAddress

On Thu, Oct 6, 2011 at 11:14 PM, Dilip Pandey dilipan...@gmail.com wrote:

 Good job Rajan... !!

 Few months back, I also had one software viz Bad Copy Pro which I used
 to recover corrupted fils, which I lost - not sure if you also have
 such kind of software.

 Thanks,
 DILIPandey



 On 10/6/11, rajan verma rajanverma1...@gmail.com wrote:
  hi
  See the attached Workbook,i think some Content of this workbook are
  currupted. i have recorved this workbook.
 
  Rajan
  On Wed, Oct 5, 2011 at 3:20 PM, Sibasankar Sahoo
  siba.sibasan...@gmail.comwrote:
 
  Dear all
  i cannot open this attached file. so please help me in this regards.
  thanks
 
  --
  With Regards,
  Sibasankar Sahoo
 
  --
 
 
 --
  Some important links for excel users:
  1. Follow us on TWITTER for tips tricks and links :
  http://twitter.com/exceldailytip
  2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
  To post to this group, send email to excel-macros@googlegroups.com
 
  
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel
 
 
 
 
  --
  Regards
  Rajan verma
  +91 9158998701
 
  --
 
 --
  Some important links for excel users:
  1. Follow us on TWITTER for tips tricks and links :
  http://twitter.com/exceldailytip
  2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
  To post to this group, send email to excel-macros@googlegroups.com
 
  
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel
 


 --
 Thanks  Regards,

 DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
 Mobile: +91 9810929744
 dilipan...@gmail.com
 dilipan...@yahoo.com
 New Delhi - 62, India

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ A macro pauses execution for no reason

[rajan verma]

Use application.enableCancelKey  false at the top of module and true
at  the end of module

On 09/10/2011, hanumant shinde arsfan2...@yahoo.co.in wrote:
 Hi Paul,

 this is superb i never knew this thing. never even thought this might be
 happening.
 thanks for sharing it.





From: Paul Schreiner schreiner_p...@att.net
To: excel-macros@googlegroups.com
Sent: Friday, 7 October 2011 4:05 PM
Subject: Re: $$Excel-Macros$$ A macro pauses execution for no reason


You said that it stops at a random point.
It it the same point every time? or a different (random) point?

I've encountered something similar, it's as if a breakpoint is being saved.
Even when I exit Excel and re-open the file.

When it stops, I was able to select Debug- Clear_All_Breakpoints
 (ctrl-shift-F9)
then save it, and the stopping... stopped.

Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-






 From: carl.malmquist carl.malmqu...@gmail.com
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent: Thu, October 6, 2011 6:16:36 PM
Subject: $$Excel-Macros$$ A macro pauses execution for no reason

A coworker sent me a workbook with a macro that runs fine on my
laptop.  On her laptop, the macro runs and at a random point within
the macro, it pauses, as if that spot in the code has a break point.
Hitting run restores the macro to running and it completes normally.

Has anyone experienced with with their own code?  Does anyone have any
suggestions for a fix?

Thanks.

--
--
Some important links for excel
  users:
1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

 --
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




 --
 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
Sent from my mobile device

Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need Help

[rajan verma]

See if it helps :

https://sheet.zoho.com/excelviewer

On Tue, Oct 4, 2011 at 9:33 AM, syed aliya raza hashim
hashim...@gmail.comwrote:

 Can excel file such as reports be access from web or can be acccess as web
 pages suppose we have 10 sheets but from some url we want to see the reports

 --
 syed aliya

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ I need help

[rajan verma]

Hi,
Do You want something Like this :
Sub MakeComponentinRunTImeOnSpreadSheet()
On Error Resume Next
Dim cb As OLEObject
n = 5
For i = 1 To 10
 Set cb = ActiveSheet.OLEObjects.Add(classtype:=Forms.Checkbox.1)
With cb
.Top = n
.Object.Caption = Do you want to Select Range
.LinkedCell = Active.Offset(0, 5).Address
.Object.Value = False
.Visible = True
.
End With
ActiveCell.Offset(1, 0).Activate
Set cb = Nothing
n = n + 20
Next
End Sub


Run this Code or you can see the attached File :

On Tue, Oct 4, 2011 at 11:38 AM, Ahmed Emam aaa222e...@gmail.com wrote:

 Hi all members,

 I need an Excel sheet that contains check list for about 20 items , and
 that will be as a to-do note.
 Can anyone help me?

 Thanks in advance

 --

 ===*
 *

 *Ahmed Abu Al magd** Al emam***
 General Accountant
 *Al-Amana Technology Est. for Contracting*
 Imam Muslim St., Dirab Road,Al Shifa.Saudi Arabia
 P.O. Box 331240 Riyadh 11373

 Tel   : +966-1- 423 9742
 Fax : +966-1- 423 9734
 Mobile  : +966-530722135

 E-mail   : audi...@alamana-tech.com
 www.alamana-tech.com



 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


CheckBox.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

[rajan verma]

Try this :

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Err:
Dim lngValueAs Long
Dim intICounter As Integer
Dim strMsg   As String
Dim lngValue2   As Long
lngValue = Target.Value
lngValue2 = Target.Offset(0, -1).Value
If Intersect(Target, Range(C:C)) Then
For intICounter = 1 To Target.Row - 1
If Range(B  intICounter).Value = lngValue2 And Range(C 
intICounter).Value = lngValue Then strMsg = strMsg  Row  intICounter 
vbCrLf
Next intICounter
End If
If strMsg   Then
strMsg = Duplicate Record of   Target.Value  vbCrLf  vbCrLf 
strMsg
MsgBox strMsg
End If
Err:
If Err.Number  0 Then
Exit Sub
End If
End Sub


On Wed, Oct 5, 2011 at 7:02 AM, ChilExcel chilexcel...@gmail.com wrote:

 Thanks Rajan I need is to columns B and C (together)
  containing the mirrored pair in same row
  good solution you propose, but only in column B duplicate

 Thanks Rajan

   2011/10/4 rajan verma rajanverma1...@gmail.com

  Try this Code :
 this Code enable you to check the duplicate entry at the time of Data
 Entry ..

  Private Sub Worksheet_Change(ByVal Target As Range)

 Dim lngValueAs Long
 Dim intICounter As Integer
 Dim strMsg   As String
 lngValue = Target.Value
 If Intersect(Target, Range(B:B)) Then
 For intICounter = 1 To Target.Row - 1
 If Range(B  intICounter).Value = lngValue Then strMsg =
 strMsg  Row  intICounter  vbCrLf
 Next intICounter
 End If
 If strMsg   Then
 strMsg = Duplicate Record of   Target.Value  vbCrLf  vbCrLf 
 strMsg
 MsgBox strMsg
 End If

 End Sub


  On Mon, Oct 3, 2011 at 10:15 PM, ChilExcel chilexcel...@gmail.comwrote:

 hi

 i Need VB lines codes for
 Alert MsgBox Pair duplicate entry in row

 Column D function account and duplicates alerts (NO Problem!)

 Attach File , thank you all

 --
 Visita ; http://sites.google.com/site/chilexcel/Home
 Visita ; http://www.youtube.com/user/timextag41

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 Regards
 Rajan verma
 +91 9158998701

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 Visita ; http://sites.google.com/site/chilexcel/Home
 Visita ; http://www.youtube.com/user/timextag41

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Dashboards

[rajan verma]

Hi,
DashBoard is nothing More then a Understandable Presentation of Analys data
, it can contain Many Dynamic charts , Pivot table , Functions... Keep the
Simplicity of data presentation at the time to making a dashboard, Please
Visit this page to know more about DashBoards.

http://www.inetsoft.com/products/dashboard_examples/




On Mon, Oct 3, 2011 at 9:08 AM, Susan 1 sunni...@gmail.com wrote:

 I am interested in learning how to create dashboards, but am finding there
 isn't much help out in the internet websites.

 Can someone send me a useful book, or website that teaches Dashboard for
 'free'?

 Thanks!

 Sunnie

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ find doubling

[rajan verma]

Hi
sort your Data and Insert A Coloum and insert this Function :

=Countif($A$1:A1,A1)
On Mon, Oct 3, 2011 at 11:48 AM, Suman ksuman1...@gmail.com wrote:

 Use this =countif(A:A,A2)1 in conditional formating. Its compares all of
 the values in column A to the contents of cell A2 the condition is TRUE if
 there r more den one. After dat set the format if there r duplicate. Then
 use filter by color.


 On Sun, Oct 2, 2011 at 11:05 AM, anil kumar kmr7a...@gmail.com wrote:

 Hi suman,


 I have a address software in which data enterd by other opprters and I
 think some data is double so i want to export data from there in excel short
 out double data than i will remove that data from software. so i wanted to
 printout that double address.




 Anil



 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --







«•´`•.(*•.¸(`•.¸*¸.•´)¸.•*).•´`•»
 «´¨*•.¸¸.*.~*--Suman --*~..*.¸¸.•*¨`»
«•´`•.(¸.•´(¸.• * •.¸)`•.¸).•´`•»

 Mob: +91 9810333884

   --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
A_html_m691da4f3.gif

Re: $$Excel-Macros$$ ragarding date format in excel vba

[rajan verma]

Find the attache Sheet:

On Mon, Oct 3, 2011 at 12:34 PM, Sanjib Chatterjee 
chatterjee.kolk...@gmail.com wrote:

 dear Sir,

 I am facing a problem in Excel.  I like to put the dae value in excel in
 dd/mm/ format.
 But like to get back the result in dd-mmm- format.

 is there any vba code by which I can solve the problem?

 One of my friend suggested to use split and dateserial function in VBA
 EXCEL.

 please help me and oblige.

 thanking you in advance

 Sanjib

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Book1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Urgent Help!

[rajan verma]

Hi
Try a Function Like this  to get the data.

='C:\Documents and Settings\HAPPY 2\Desktop\[Book1[Sheet1]]Sheet1'!A1

On Mon, Oct 3, 2011 at 2:18 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Dear Rashid,

 Please try through below link, I hope it will be help to u..

 http://www.wikihow.com/Recover-a-Corrupt-Excel-File

 --
 Thanks  regards,
 Noorain Ansari
  *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
   On Mon, Oct 3, 2011 at 10:40 AM, rashid memon 
 mr.rashidme...@gmail.comwrote:

 Hi,

 Can any one help me. My Excel Files are *corupted *Please tell me what i
 can do for *Recover Excel files.*
 *
 *
 *
 *
 Rashid Memon.

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel





 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel