Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

2012-02-04 Thread Anoop K Dixit
Hi Sanjib, Please find attachment. Regards, Anoop On Fri, Feb 3, 2012 at 1:28 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear Experts, Please See the attachment and Help me regarding VLOOKUP FUNCTION Thanking you in Advance Sanjib -- - -- FORUM RULES

RE: $$Excel-Macros$$ paste special problem

2012-02-04 Thread danial mansoor
Option Explicit Sub dovalues() 'Application.ScreenUpdating = False Dim ws As Worksheet For Each ws In ActiveWorkbook.Sheets ws.Cells.Copy ws.Cells.PasteSpecial (xlPasteValues) Next ws 'Range(a1).Select Application.ScreenUpdating = True Application.CutCopyMode = False End Sub From:

Re: $$Excel-Macros$$ Urgent Help

2012-02-04 Thread Lakshman Prasad
Dear Pravesh,   You can use lookup too   VLOOKUP(I13:I19,D11:E24,2)     From: PRAVESH KUMAR praveshkash...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, 3 February 2012 11:06 PM Subject: $$Excel-Macros$$ Urgent Help Hi, please help ASAP. please

$$Excel-Macros$$ Re: Currency Calculator to calculate the cells values. (But it should not disturb the programmed cells).

2012-02-04 Thread Kris
Hi Please find attached. Kris -- 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)

Re: $$Excel-Macros$$ paste special problem

2012-02-04 Thread dguillett1
Please tell me WHY what I send did NOT work as desired. It was TESTED. It is ONLY looking at cells with formulas instead of ALL CELLS and does NOT need to copy/paste. Your procedure could take a LONG time to execute. Sub dovalues() dim ws as worksheet For Each ws In ActiveWorkbook.Sheets With

Re: $$Excel-Macros$$ paste special problem

2012-02-04 Thread dguillett1
Original Post “i have a big file with many sheets i want to convert formula in values,if i do individually it will take lotes of time can any one tell me the macro which will work?” Says nothing about the type formula so my code looks at ONLY cells that contain ANY and ALL formulas in the

$$Excel-Macros$$ Text Box - Properties

2012-02-04 Thread Cab Boose
Hi I have a userform open with a 'text box' . Want to link with a cell in sheet. However the 'text box' properties does not show a 'linked cell' heading. I am sure it use to. How do I restore the missing property or is there another text box I should use. Thks Charlie -- FORUM RULES

RE: $$Excel-Macros$$ Text Box - Properties

2012-02-04 Thread Asa Rossoff
The Active X Text Box control can be linked to a cell, but I think it is only available for use on a worksheet, not a userform. and everyone keeps telling me to avoid Active X controls on worksheets like the plague, anyway. To duplicate the linking behavior, you'll have to use a little VBA

$$Excel-Macros$$ Need a small MACRO to SPLIT

2012-02-04 Thread Somnath Khadilkar
Good Morning. I receive XL file comprising 1-sheet. Depending upon Colm 'A' I need to SPLIT this single sheet into MULTIPLE sheets [ with this colm as it name. ] The Distinct entries in this colm. would be less than say 25, but the no of entries cud be anything say 10 to 100 K. Regards --

$$Excel-Macros$$ Cashflow filter data not coming all data

2012-02-04 Thread chandra sekaran
Hi This is code wrriten by Rajan verma, it is small issues is there when Filter Collection journal in data sheet it will not pickup all collection journal data in my out put sheet what is issues below code Dim rngRowData As Range Dim rngCell As Range Dim wksOutPut As

$$Excel-Macros$$ no mail since long

2012-02-04 Thread Nemi Gandhi
Since Jan 19, i am not getting mail from this group. Whats wrong? it is so useful and learning. Secondly, i am facing problem in getting result from cell link , which is entered from another cell link. if in same cell, value is entered directly, then formula works. why? what is solution. --

Re: $$Excel-Macros$$ Text Box - Properties

2012-02-04 Thread Cab Boose
Hi Asa Thankyou very much for the code. Magic. Will be using the info you provided. Will include in ;my library. Another similiar question being posted shortly re vlookup in text box, another little project. Thanks Charlie On Sun, Feb 5, 2012 at 2:37 PM, Asa Rossoff a...@lovetour.info

Re: $$Excel-Macros$$ no mail since long

2012-02-04 Thread xlstime
Hi Nemi, Check your group membership setting ( go to edit my membership (* https://groups.google.com/group/excel-macros/subscribe?hl=en* ))... and your second question i think it is sheet calculation problem please send the example On Sun, Feb 5, 2012 at 11:59 AM,

Re: $$Excel-Macros$$ To excel macro team

2012-02-04 Thread xlstime
Hi Pascal, Check your group membership setting ( go to edit my membership (* https://groups.google.com/group/excel-macros/subscribe?hl=en* ))... On Thu, Feb 2, 2012 at 3:18 AM, Pascal Baro bpascal...@gmail.com wrote: Hi, I'm not receiving mail summary from group posting

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

2012-02-04 Thread Rohan Young
CONGRATULATION NOORAIN BHAI, CARRY ON. On Sat, Feb 4, 2012 at 10:47 AM, Venkat CV venkat1@gmail.com wrote: Congrats... Noorain Everyone... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71 * On Wed, Feb 1, 2012 at 10:11

RE: $$Excel-Macros$$ vlookup in Text Box

2012-02-04 Thread Asa Rossoff
Hi Charlie, Glad my last post helped :) From a quick look I see two issues/potential issues: 1. The syntax error: TextBox5.Value = WorksheetFunction.VLookup(TextBox8.Value, Range.(DBase),2,False) Remove the . between Range and (Dbase): TextBox5.Value =