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
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:
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
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)
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
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
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
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
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
--
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
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.
--
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
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,
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
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
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 =
16 matches
Mail list logo