On Fri, Mar 19, 2010 at 6:24 PM, Jai wrote:
> Dear All,
>
> I have a big card text but he not wrok properly when we convert the amount
> suppose that 100 he gives the reults Million but we net Indian Rupes i
> want to say he convet the amount in indian Rupess. Please Help me.
>
> --
> Thanks
Mahesh: Thank you so much. This works great! Thanks again.
On Mar 19, 6:59 am, Mahesh parab wrote:
> Hi Kevin
>
> Please find attach sheet, hope this is what u want.
>
> Right Click on sheet1 tab & view code change this as per your requirement
>
> Private Sub Worksheet_Change(ByVal Target As R
Thank you very much. I appreciate.
On Fri, Mar 19, 2010 at 9:13 PM, rf1234 rf1234 wrote:
> Hello Dear
> Attached is the sample sheet, Perhaps it can help you to print & achieve
> suitable result.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hope It Will Help
> Happy To Help
> :)
> Shyam
>
>
> On Fr
Mahesh: Why do I need code in module 1 and module 2? Does it work in
hand with the sub procedure in sheet1?
On Mar 19, 6:59 am, Mahesh parab wrote:
> Hi Kevin
>
> Please find attach sheet, hope this is what u want.
>
> Right Click on sheet1 tab & view code change this as per your requirement
>
>
I have this code that replaces a "-" in a column.
It does just that, but when I link that workbook to Access and use a
"is not null" filter in a query the ones that are blank come up in the
query.
Thus my code is doing something to each cell to make Access think the
cell is not blank (whent it appe
Hi Andy,
Not quite sure what date fields you want to match to what.
Is it possible to attach the worbook?
Regards - Dave.
Hey all,
I'm trying to cut down on loading times by converting a load of
formulae to code.
I'm stuck on this particular formula -
=IF(ISERROR(VLOOKUP((C3),fortnight,3,FALS
Hi,
Do we have any tools to automate financial reports?
--
Regards,
Shilpa
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join
Try something like this:
Sub Macro1()
Dim sheetnames As Variant
sheetnames = Range("C1:C10").Value
For i = 1 To UBound(sheetnames)
If sheetnames(i, 1) <> "" Then
Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Name = sheetnames(i, 1)
End If
Next i
End Sub
On Mar 19, 9
Dear All,
I have a big card text but he not wrok properly when we convert the amount
suppose that 100 he gives the reults Million but we net Indian Rupes i
want to say he convet the amount in indian Rupess.
--
Thanks For Mail.
--
Here a picture
http://groups.google.com/group/excel-macros/web/link%20error.JPG
searching for the broken link 'array1031table' doesn't exist anywhere
in the workbook.
also the "location" is blank where on a valid link this would be the
file path.
changing the source doesn't keep. as soon as you cl
Could anyone suggest the manner i could to the following ;
1. Add an event in excel macro to insert particular Sheet of an Workbook
depending upon count in a column &
2. Name of the new worksheet will be content of column.
Example: In Workbook named "DATA", Sheet 1,C1 to C3 contain A,B & C
respec
Where does it tell you which cell contains the link?
I've run a search on the entire workbook and I don't think the link
actually exists.
On Mar 18, 12:08 pm, Michael wrote:
> It should tell you which cell contains the link. Go to it and delete
> it. You will need to hard code the data.
>
> On
But how to create now a real menu with submenus in a form?
Is there a control available that represents a menu and which is not a
controlBarItem?
> I would suggest creating a userform.
> If you already have a button, then you can use it to show the userform.
> you could even create click-events on
Hi All,
Could you please provide me the VBA to caputre the system time in an excel
spread at the time of locking the system.
Kind Regards
SPS
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Hey all,
I'm trying to cut down on loading times by converting a load of
formulae to code.
I'm stuck on this particular formula -
=IF(ISERROR(VLOOKUP((C3),fortnight,3,FALSE)),"",VLOOKUP((C3),fortnight,
3,FALSE))
The main problem I seem to be having is how to amend the code to
properly detect whe
what is it supposed to do?
On Fri, Mar 19, 2010 at 9:49 AM, Puttaswamy wrote:
> How to use that, its not working for me? what is the use of that sheet?
>
>
> On Fri, Mar 19, 2010 at 11:54 AM, ashish koul wrote:
>
>> just find it on goole see if it useful to u
>>
>> --
>>
>> -
Hello Dear
Attached is the sample sheet, Perhaps it can help you to print & achieve
suitable result.
Hope It Will Help
Happy To Help
:)
Shyam
On Fri, Mar 19, 2010 at 12:52 PM, OSAVentures Calamba wrote:
> Hi All, I'm trying to fill C6 with value of 1 then selecting that and
>
I would suggest creating a userform.
If you already have a button, then you can use it to show the userform.
you could even create click-events on the elements of the userform
so that it closes/hides the userform when an item is selected.
From: Erwin Ahlers
To:
It's the "without looking at the code" part that makes it difficult !!!
There are LOTS of ways to speed up loops, but everything
doesn't always apply!
first of all, what version of Excel are you using?
Excel2007 has a way of dropping to a lower priority after several seconds,
thus causing long ru
How to use that, its not working for me? what is the use of that sheet?
On Fri, Mar 19, 2010 at 11:54 AM, ashish koul wrote:
> just find it on goole see if it useful to u
>
> --
>
> --
> Some important links for exce
*I was working on my data sheet and countered with one problem
**I required filters in two row ranges on being specific I want first filter
to be placed for data range from Row no. 1 to 200 and second one I want for
Row no. 210 to 350.
So I try to do it with filter options that are available in E
Dear Masters,
I want to create a macro through which i want to move a copy of active
sheet and after that i want to run my macro in duplicate sheet.
Macro will delete the row based on following criteria.
1. Blank column A: If in column A the cell is blank macro will delete
the entire row.
2. Speci
Hi All, I'm trying to fill C6 with value of 1 then selecting that and
filling the cell below it with series until the last row of B, my code is
not working. whats wrong? thanks
Sub Fillnumber()
ActiveSheet.Unprotect
curr_row = Range("C6").Row
curr_col = Range("C6").Column
last_row
Hi,
Can u explain me what is ur query
i did some this pls have a look
On Thu, Mar 18, 2010 at 2:31 PM, Venkatesan c wrote:
> Dear All,
>
> Any one can Assist me attached file query It's something like reverse Lookup
>
> --
>
24 matches
Mail list logo