Dear Rakesh,
U can use Data>Validation>
Fill the options in the Range:List
Regards
Ramkesh
On Mon, Apr 11, 2011 at 3:54 PM, rakesh kumar wrote:
> HI Group,
>
> I have been trying to put one drop down menu in cell, which should be
> visible only when the particular cell is clicked. I have seen
Thanks Siti, Ranjan
for sharing useful information
On Mon, Apr 11, 2011 at 1:25 PM, rajan verma wrote:
> *"=_xlfn shows that the following Fuction exist in higher Version of excel
> but not in Lower Version.. Exce Automatically Include =_xlfn .. when file
> open in Lower Version of Excel,,*
>
>
I was going to ask what it was doing, or not doingif you stepped through the
code.
But I think I see your main problem.
the statemtent:
Select Case "M10701403"
means nothing..
you're not COMPARING anything!
I think what you're wanting is:
Select case ws.Name
Case "M10701403"
'
Hi Team,
I have attached the sample spreadsheet with my query. Kindly help me to
solve the same.
Thanks,
Sharma
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http:/
Dear all,
Following code i am using to select each worksheet (except ) to copy and
paste special values in each worksheet in same workbook. But, i am not
getting desired output .
Could you one help to rectify the following code;
Sub ConvertToValues()
Dim ws As Worksheet
For Each ws In Worksheet
HI Group,
I have been trying to put one drop down menu in cell, which should be
visible only when the particular cell is clicked. I have seen such drop down
menu to appear in many spreadsheets posted here for examples, but couldn't
achieve that.
--
Rakesh
--
*"=_xlfn shows that the following Fuction exist in higher Version of excel
but not in Lower Version.. Exce Automatically Include =_xlfn .. when file
open in Lower Version of Excel,,*
On Sat, Apr 9, 2011 at 7:19 PM, Dhananjay Pinjan wrote:
> Dear Ashish,
>
> Pl. explain what is *"=_xlfn."*SUMIFS
Awesome Rajan,
Can you please share your code with us, if possible???
I'm working on the same kind of stuff and your code might be helpful in
that.
Thanks,
Manoj Kumar
On Sat, Apr 9, 2011 at 12:30 AM, rajan verma wrote:
>
> HI Karan..
> find the attached sheet.. hope it will complete your tas
Well, I don't see any big issue in the code.
Try putting j instead of (6+i) and remove the word "format" before End Sub.
regards,
Mrinal
On Mon, Apr 11, 2011 at 7:50 AM, Financeguy wrote:
> Hi All,
>
> I've got some code that's a bit buggy for a stock analysis
> spreadsheet, and in need of som
Sir,
Thanks for the codes. But it lacks two things;
1. Objective is to create Worksheet with Value,Format & JPEG image attached
in the source worksheet but the Macro copies the worksheet along with
formula and excludes JPEG image .
2. If possible is it possible to ask from user to specify which
Hi,
What is the error message?
Add :
Debug.Print i
Before this line to check the value of I .
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Financeguy
Envoyé : lundi 11 avril 2011 04:21
À : MS EXCEL AND VBA MACRO
11 matches
Mail list logo
