You have option explicit at the top so you need to declare variables. dim lr as long
Attach or send me your file if necessary From: SAJID MEMON Sent: Wednesday, October 05, 2011 11:20 AM To: Excel Group Subject: $$Excel-Macros$$ Project Part Error Dear Dguillett1 & Roshan Mathew, [ Dguillett1] I have given expriment as per your answer, in my project error is display lr is not defined! , this question has come. There is no doubt my desire is complited but plz give me detail trik of your project ( i have mentioned enclosed here error look like...) [Roshan Mathew] I had changed currecny format from contol penal as you have give me as snap. but when i typed in excel it's not convert look like as per my desire. plz give me some tips. Awaiting both experts answers yours Sajid memon +919437638986 -- ---------------------------------------------------------------------------------- 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
