Dear Sanjib,
Please find attachment in 2003 Version.
On Fri, Feb 17, 2012 at 1:16 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear N ANSARI,
WOULD YOU PLEASE CREATE THE ATTACH FILE IN 2003 FORMAT. .
THANKING YOU IN ADVANCE.
SANJIB
On Thu, Feb 16, 2012 at 6:34 PM,
Dear Veeru,
http://www.iopus.com/download/iMacros-Manual.pdf
On Fri, Feb 17, 2012 at 10:03 AM, Veeru TOC veerub...@gmail.com wrote:
Dear Rajan sir,
Plz send any material for I-Macro
On Thu, Feb 16, 2012 at 9:38 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Try to
Dear Noorain
I have files in different sub folders...
as per below macro i may need to set number of sfol path ...
sfol = c:\MyFolder ' change to match the source folder path
Kindly suggest if i m wrong...
On Fri, Feb 17, 2012 at 12:55 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Hi
Hi Shaik,
Check this link...
http://www.screencast.com/t/69UdkpgmFv
Regards,
MARIES.
On Thu, Feb 16, 2012 at 3:05 PM, Shaik Waheed waheedb...@gmail.com wrote:
Hi Maries,
Can u tell me how did u do that..
On Thu, Feb 16, 2012 at 3:25 PM, Maries talk2mar...@gmail.com wrote:
Find the
Dear Chan
kindly also let the group know where and which conditional formatting u
want in your sheet
On Fri, Feb 17, 2012 at 2:01 PM, Darwin Chan darwin.chankaw...@gmail.comwrote:
Dear group,
i have a workbook which is set as shared, however, i found it could not
apply conditional
many many thank you N Ansary for you quick reply
regards,
Sanjib
On Fri, Feb 17, 2012 at 2:02 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Sanjib,
Please find attachment in 2003 Version.
On Fri, Feb 17, 2012 at 1:16 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Darwin,
You can use vba coding for conditional formatting during share mod
On Fri, Feb 17, 2012 at 2:01 PM, Darwin Chan darwin.chankaw...@gmail.comwrote:
Dear group,
i have a workbook which is set as shared, however, i found it could not
apply conditional formatting. Could anybody
Hi Priyanka,
by using this macro you can move source folder with subfolder to change
sfol = c:\MyFolder path.
On Fri, Feb 17, 2012 at 3:04 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Dear Noorain
I have files in different sub folders...
as per below macro i may need to set number of sfol
Dear Noorain
I want to move only .xls files not the root folder also with it
On Fri, Feb 17, 2012 at 3:39 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Hi Priyanka,
by using this macro you can move source folder with subfolder to change
sfol = c:\MyFolder path.
On Fri, Feb 17,
Hi Maries,
Thats really great..Thank you..
On Fri, Feb 17, 2012 at 3:10 PM, Maries talk2mar...@gmail.com wrote:
Hi Shaik,
Check this link...
http://www.screencast.com/t/69UdkpgmFv
Regards,
MARIES.
On Thu, Feb 16, 2012 at 3:05 PM, Shaik Waheed waheedb...@gmail.comwrote:
Hi
Dear Waseem,
You can use RTRIM Function...
like..
Function Rtrim(rng As Range) As String
Rtrim = VBA.Rtrim(rng)
End Function
On Fri, Feb 17, 2012 at 4:23 PM, Waseem Saifi waseemsa...@gmail.com wrote:
Dear All, I want to know that in Excel, in a cell contains a text string,
which has many
Dear Experts,
I am trying to make a document tracker, where I want to put date
automatically. If you see the attachment, when I am giving serial no.
Document no. date will be appeared automatically. But next day that date
changing to current date which I don’t want.
Is there any process to
thank you so much noorain.
But is it Possible without using vba?
On Fri, Feb 17, 2012 at 4:28 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Waseem,
You can use RTRIM Function...
like..
Function Rtrim(rng As Range) As String
Rtrim = VBA.Rtrim(rng)
End Function
On Fri, Feb
kindly find the attached file
On Fri, Feb 17, 2012 at 4:30 PM, Kal xcel kalx...@gmail.com wrote:
Dear Experts,
I am trying to make a document tracker, where I want to put date
automatically. If you see the attachment, when I am giving serial no.
Document no. date will be appeared
Thank you Noorain Bhai
On Fri, Feb 17, 2012 at 2:59 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Shankar,
Please try it..
Private Sub TextBox2_Enter()
If TextBox1.Text = Then
MsgBox Mandatory Field, vbQuestion + vbOKOnly, Alert
TextBox1.SetFocus
Else
TextBox2.SetFocus
End
Dear Priyanka,
Thanks for your super fast reply.
I have some queries
1. At C2 there is today(), today it is 17th, tomorrow that will be 18
and all date under C2 will change, so what will be the solution
2. If I gap one day…..suppose there is no entry on 18th , so how it
I think this is what you need. It will enter current system date when you
add a new serial no. and once entered, will not change it, yesterday,
today, tomorrow, ever, :)
PS: A one line macro is used, so enable macros.
Let me know if this doesn't solve your query.
Cheers!
AJ
On Fri, Feb 17,
Dear All,
Please explain what do you mean by imacros..
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI
Sent: 17 February 2012 15:04
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ I Macros tutorial
'=LEN(A1)-SEARCH(@,SUBSTITUTE(A1, ,@,LEN(A1)-LEN(SUBSTITUTE(A1,
,+1
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Waseem Saifi
Sent: Friday, February 17, 2012 4:53 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to find out rightmost space in a cell of text
Or, to not clutter the file with extra formulas, right click sheet tabview
codeinsert this macro.
When you make any entry in col B col C gets todays date which won’t change
unless you change col B cell
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column 2 Then Exit Sub
Try this :
=MAX(--(MID(A1,ROW(INDIRECT(1:LEN(A1))),1)=
)*ROW(INDIRECT(1:LEN(A1 with CSE
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Feb/Fri/2012 06:48
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
From right.
=Len(A1)- MAX(--(MID(A1,ROW(INDIRECT(1:LEN(A1))),1)=
)*ROW(INDIRECT(1:LEN(A1+1 with cse
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: Feb/Fri/2012 07:35
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ How to find out rightmost space in a cell
Hello, I have a spreadsheet and It has many columns and I want to
create a range for each column automatically and name it based on the
value at the top row. Unfortunately, this code i created doesn't work.
Can anyone help me fix this code?
Any help would be great!
Sub test()
Dim icol As
Hi
Sub kTest()
Dim i As Long, r As Long, c As Long
c = Cells(1, Columns.Count).End(-4159).Column
For i = 1 To c
r = Cells(Rows.Count, i).End(3).Row
If r 1 Then Cells(1, i).Resize(r).Name = Cells(1, i).Value
Next
End Sub
Kris
--
FORUM
Rajan,
The formula you posted would give 1, if there is no word in the cell and
secondly if there is only one word, the result would be 1 + length of the
word, which is incorrect.
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
Ah.. thanks for correction..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kris
Sent: Feb/Fri/2012 08:48
To: excel-macros@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ How to find out rightmost space in a cell
of text string with many spaces.
Hi Don, why do you believe this is a bad idea? I'm just curious.
any ideas as to how else to go about this task?
On Feb 17, 10:11 am, dguillett1 dguille...@gmail.com wrote:
I REALLY think this is a BAD idea in that there are other and BETTER ways to
do this without cluttering your project with
This macro using DIR and NAME will move and/or rename your files without doing
anything else. Modify to suit
Sub MoveFilesToNewFolder()
Application.ScreenUpdating = False
Dim FN As String
Dim FileLocation As String
FileLocation = c:\oldfolder\*.xl*
FN = Dir(FileLocation)
Do Until FN =
Dim
In my experience many names just serve to clutter the file. Tell us what you
want to do with the named ranges along with any related macro you have
developed and you will bet comments.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Matt
Sent: Friday,
hi Noorain,
Can I Macro run thourth VBA Macro. Form Example I have to do certain
activity with dumps after axtracting, so can i write any macro to run i
macro first and then run Excel Macro..
Pls suggest.
Regards
Pankaj k Pandey
On Fri, Feb 17, 2012 at 5:46 PM, Amit Desai (MERU)
Well, I wanted to loop through each column in this sheet and name it
as a range based on the first cell of each column, so that I can refer
back to a particular range with some formulas on the sides later on.
https://www.box.net/shared/57z5y97q7hrnuovp9eun
On Feb 17, 11:03 am, dguillett1
Dear veeru
My personal mail id is finos...@gmail.com or finos...@hotmail.com
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Veeru TOC
Sent: Thursday, February 16, 2012 4:38 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
I thought about the suggestion you made before but I didn't want to
have to name each range one-by-one. It looks like i would have to.
On Feb 17, 11:59 am, dguillett1 dguille...@gmail.com wrote:
How about a couple of formula examples so we can make suggestions.
Here is an example of mine to
Hi Matt
you need to remove spaces , , etc sign from header while creating name
ranges
like
p i in cell aa1 remove sign
try these
Sub dynamic_Name_ranges()
Dim rng As Range
Dim I As Integer
For I = 1 To 49
Set rng = Sheets(1).Range(Sheets(1).Cells(2, I).Address :
Hi Amit,
iMacros is the *only* software that can *automate both Internet Explorer
and Firefox.* You can control both web browsers directly from
Excel.*iMacros works with every website
*and can automate even the most complicated websites that use dialog boxes,
frames, Javascript and AJAX can be
Matt. Did you try this? I didn't name the ranges, I just went and looked for
the column with the name at the top...
Examples of YOUR formulas that would require named ranges___?
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Matt
Sent: Friday,
Maries,
That was awesome!! I was asking myself what if there is a need to
expand the range? So I am wondering if using a range name will do the
trick i.e update the range : Formulaname manager ( I am using
excel 2010).I've tried it but it didn't work.
Please advise.
Regards
On Feb 17, 5:39 am,
You *cannot *view the VBE when the file is in share mod, and hence you
cannot build the code in conditional formatting. Even manually also, you
will not be able to setup a conditional format. If the conditional format
was already setup, then that will work even if the file is shared.
Sam Mathai
*Simple...*
On Fri, Feb 17, 2012 at 7:19 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Why VBA?
Select the data
Press Shift+Ctrl+F3
And Choose Top Row and Ok
** **
** **
Regards
Rajan.
--
FORUM RULES (986+ members already BANNED for violation)
We have a winner!
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Haseeb Avarakkan
Sent: Friday, February 17, 2012 2:00 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: How to find out rightmost space in a cell of text
string with many spaces.
Another one,
I'm trying to create an inventory tracking system to pinpoint a
specific
location(a simple one) which, when the part number is entered into the
Inputbox,
Excel will go to, select and highlight that cell where the part number
is
located. I'm familiar with VBA just don't know the code, also using
Hi noorain,
thanks for your support..can the result be provided on 2003 version.
NOORAIN ANSARI wrote:
Dear Prabhat,
Please visit on
http://www.excelvbamacros.com/2011/06/send-emails-and-attach-filtered-data.html
See attached sheet
--
Thanks regards,
Noorain Ansari
You would need to use Match to find the locationof thecell. Than you would
use Cell(?,?).format.interior.color= to highlight the cell. Lastly use
ScrollIntoView (I think it is called that) to make the cell sit in the
visible area.
On 18 February 2012 11:29, Bob bobandrich...@comcast.net wrote:
Hi Kal,
Here's a solution using a UDF (user-defined function). It solves an issue I
saw with the other proposals that they will generate a new date any time a
cell is edited, even if not changed, or even during any worksheet
calculation. It also works when multiple serial numbers or document
HI,
Please help...for conditional formatting
PFA attached file
Thanks
Pravesh Kashyap
--
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
Hi Vikas
You have asked twice and got no response. If you give more information you
are more likely to get a response.
How are you listing the files? Are you putting a listing in Excel? Are
you doing it using VBA? If so can we see the code? If not can we see the
workbook?
Or are you
Pls find attached file.
On Sat, Feb 18, 2012 at 12:38 PM, PRAVESH KUMAR praveshkash...@gmail.comwrote:
HI,
Please help...for conditional formatting
PFA attached file
Thanks
Pravesh Kashyap
--
FORUM RULES (986+ members already BANNED for violation)
1) Use
=MATCH(1,--IF(LEFT(RIGHT(A1,ROW(1:100)),1)= ,1),0) with CSE
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Feb/Sat/2012 04:56
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: How to find out rightmost space in a
Hi Hilary
Sorry to take forever to respond. Try the attached. I have set my calcs
out rather than combine them in one massive formula so they are easier to
read and understand.
Best regards
David Grugeon
On 16 February 2012 18:44, hilary lomotey resp...@gmail.com wrote:
Thanks Dave,
Forgot the attachment
On 16 February 2012 18:44, hilary lomotey resp...@gmail.com wrote:
Thanks Dave,
thanks a lot for responding, i have attached the file to demonstrate what
i want to achieve, basically what i want is when a stock is selected i want
the needle to move to price of the
50 matches
Mail list logo