Hi,
Name: Rajesh Kunder
*TIP: Identifying Merged Cells*
**
*Please follow the below mentioned steps to identify all merged cells in
excel at one shot !*
**
**
**
1. *Ctrl+F*. Excel displays the Find tab of the Find and Replace dialog
box.
2. If necessary, click the Options button
Dear All,
This is a very important tool to convert no. in figures into words:
STEPS:
1)download the attachment and save it to hard disk.
2) Open excel and go to Tools -Add Ins
3)go to browse and select the smb.xla file from the location where u saved
it and click OK.
USE the Formula =n
Hi Vinay,
$ sign is used to make the cell references as absolute (locked), means the
references will not change if you move the formula anywhere in the
spreadsheet.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi -
Hi Ruchi,
I've tried to explain the formulas in the attachment.
Regards - Dave.
> Hi
>
> Thank you so much thats excatly i want it
> but can u plz explain me the formula u applied?
> and also 1 more thing as i m making chart of this data i want one line
> at 2:30 which showz the cut off point l
the line:
If FindCell(Counter) <> "D" Then
tests to see if the array element was NOT EQUAL to "D" (and "D" alone!)
what you WANT to do is test to see if the letter "D" is IN the string.
the function you're looking for is "Instr"
like:
If (InStr(1, FindCell(Counter), "D") = 0) then
this wi
I'm not sure if I understand exactly what you're asking.
In a MACRO, it would be very easy to check the contents of "B",
and if it contains something specific (like 1:22), then clear "A".
Like this:
For I = 1 to 1000
if (instr(1,cells(I,2),"(1;22)") > 0) then cells(i,1) = ""
next I
is that th
Absolutely.
the log file can get rather large though.
What I would suggest is this:
Create multiple log files.
(1) "Master" log file
and one log file for each userid.
then, in your file, create a workbook_open event
and delete any existing log file with the userid, and open it new.
then, create a W
I'm sorry, but there are too many confusing statements here...
I understand that you have a column of numbers and you
want to add them up until your reach (without exceeding) 5000.
What does "(doesn't matter which order)" mean?
meaning that the numbers are not sorted in any way?
or that you don't
This is something really new thanks for the same
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Rajesh Kunder
Sent: 19 June 2009 09:27 am
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$Options
Hi,
Hi,
I have inserted the following code (n.b. I have gone not into the
Modules section, but rather into the Worksheet / Change event for the
specific sheet I am working on):
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
MsgBox "A1 has changed."
End If
End Sub
Dear Abdul Raheed,
I am an old member of excel-macro, I have experience of using excel. I want to
learn VBA and VB, could you please suggest me some guidlines. I qualified MBA +
ICMA (Inter).
Regards,
Date: Fri, 19 Jun 2009 10:26:29 +0500
Subject: $$Excel-Macros$$ Excel Utility
hi dileep
can u explain m with the example by attaching the excel sheet ...so that i
can understand in a better way if u dont mind
On Fri, Jun 19, 2009 at 12:47 PM, Dilip Pandey wrote:
> Hi Vinay,
>
> $ sign is used to make the cell references as absolute (locked), means the
> references w
thanx a ton
On Fri, Jun 19, 2009 at 12:45 AM, Harmeet Singh wrote:
> Thanks Rajesh for quick response.
>
> Mahender, I hope that helps.
>
>
>
>
>
>
> On Thu, Jun 18, 2009 at 11:46 AM, Rajesh Kunder wrote:
>
>> Hey Mahender,
>>
>>N() formula is used to hide the text. Its similar to com
Dear Friends,
When ever the user open new excel the macro automatically open.
Please can any one tell me where should I save that macro.
Regards,
Shrinivas
Query Unit
Securities Services
Global Transaction Services - India.
Ph: +91-80-41446339
E-Mail: shrinivas.chidur...@citi.com
--~--~---
I have 3 questions regarding the ability to drag and drop shapes in
Excel.
1. How do I turn the "Snap to Grid" on using VBA code? I would
like to turn this on when the sheet opens (Worksheet_Open subroutine)
2. When the Snap To Grid is on how do I know what the location of a
particular sh
Dear Friends,
When ever the user open new excel the macro automatically open.
Please can any one tell me where should I save that macro.
Regds.
Shree
--~--~-~--~~~---~--~~
-
Som
There are two places for a macro that opens automatically.
One is to create a macro in a Module.
You can either rename your macro to Auto_Open,
or create a new macro called Auto_Open and within it,
run your macro.
Another way is to create a Workbook_Open event in the
ThisWorkbook module.
In this
If you right-click on your "sheet tab" and select "View Code",
do you see your change event?
If so, try setting a breakpoint on your "If" statement
and add something to A1 to see if it stops.
If it does not:
What version of Excel are you using?
When you opened Excel, did it ask you to Enable Ma
Hi Vinay,
Please find the workbook attached with the explanation. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Fri, Jun 19, 2009 at 3:16 PM, vinay keni wrote:
> hi dileep
>
> can u explain m wi
Hi Friends,
Name : Upendra Singh
TIP : Hide Data in Cell or Worksheet from praying Eyes
ðSelect the range you want to hide.
ðGo To Format=>Number=>Custom
ðIn the type Box, type three colon (;;;) and press enter.
ðThe data where the above formatting is applied wi
Dear All
I send email through attach sheet to more then one person, now i want to
insert Excel sheet data in row in table format to mail body,how can i do
it?please find below mention format of table which i want to put in Email
body, and how can i attach more then one attachment to email. please f
Hi...thanks for your response.
The specified date can be in a cell (in this case it would be sept
15). I forgot to mention that it should be only a WORKDAY that is the
output date.
Order is as you said, the column is not in any order.
I get a runtime error 438 from your code.
Hope this clears
Hi
thank u for ur explanation
u r gem man
regards
ruchi
On Fri, Jun 19, 2009 at 4:03 PM, Dave
Bonallack wrote:
> Hi Ruchi,
> I've tried to explain the formulas in the attachment.
> Regards - Dave.
>
>
>> Hi
>>
>> Thank you so much thats excatly i want it
>> but can u plz explain me the formula
Hi Paul...I did away with the sort in the macro and fixed the error (i
use excel 2003) The other part worked great.
i guess next would be to insert the date in the adjacent cell and then
loop through those that do not contain "x" and do the same. (no idea
how to do this)
Thanks for your help th
OOps, forgot to ask..
What version of excel?
My sort code probably won't run under Excel97/2003.
You'll have to record your own sort.
As for the date...
what does it have to do with anything?
is there data for multiple dates?
are you specifying which date to total?
Paul
__
Please explain the date.
is it there already? or added? added by? purpose?
Paul
From: wongsol
To: MS EXCEL AND VBA MACROS
Sent: Friday, June 19, 2009 12:58:10 PM
Subject: $$Excel-Macros$$ Re: Loop through count and add date
Hi Paul...I did away with the so
You could use the following formula:
=IF(SUMIF($B$1:$B1;$B1;$A$1:$A1)>5000-$A2;$B1-1;$B1)
just put it on the B column (row 2 and bellow) and in the B1 cell input your
desired date. Then copy the formula down...
2009/6/19 Paul Schreiner
> Please explain the date.
>
> is it there already? or ad
Hi Friends,
Name: Bakul Patel
Tip of the week;
Convert name from "bakul" to "Bakul".
If you have a big list of names & you want to make it like this then this would
be helpful.
A B Result
1 bakul =PROPER(A1) Bakul
dear upendra
i am trying it out but i am unable 2 get the thing can attach
an excel sheet & show with the example
On Sat, Jun 20, 2009 at 12:23 AM, vinay keni wrote:
> dear upendra
>
>
> On Fri, Jun 19, 2009 at 8:39 PM, Upendra Singh <
> upendrasinghsen...@gmail.com> wrote:
>
>>
thanks aa lot dilip
On Fri, Jun 19, 2009 at 8:57 PM, Dilip Pandey wrote:
> Hi Vinay,
>
> Please find the workbook attached with the explanation. Thanks
>
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 11
Hi all,
I joined this group recently in order to get some help on Macro. I do
not know much about macros but I am trying to learn and hence any help
would be appreciated. Here is my problem description,
1. There is a folder called 'pH System' which contains multiple .CSV
files which are named as
the date is added; say in cell A1. This will be the date to work
backwards from; so if i wanted the first 5000 records to start on sept
15, then i would set A1= Sept 16...this would just be to start, then I
would change the date to be something like =MIN(B1:B100)-1 wrote:
> Please explain the da
32 matches
Mail list logo
