Dear Amit,
Try it..
*Application.OnKey %{+}, short_key
*
Sub short_key()
MsgBox Sheets.Count
End Sub
You can change combination
% for Alt
(^) for Ctrl
(+) for Shift
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, Jul 10, 2012 at 11:11
Dears,
i m facing run time error 1004
For Each oitem In myItems
Sheets(Inbox Scan).Cells(i, 1).Value = oitem.SenderName
Sheets(Inbox Scan).Cells(i, 2).Value = oitem.SenderEmailAddress
'Sheets(Inbox Scan).Cells(i, 3).Value = oitem.Subject
'Sheets(Inbox
The lookup names have to be entered the same on both sheets, some need a
space and some don't have a space. Look more closely at the ones that
yield #N/A.
On Tue, Jul 10, 2012 at 5:23 AM, Deba Ranjan drdeva...@gmail.com wrote:
Hi Experts,
i am getting error in vlookups in finding the
That is what the problem, i have like wise thousand datas which manually
not possible to enter one by one, i want to look up by some eventual
formulas.
Thanks Regards,
*Deba Ranjan P*
On Tue, Jul 10, 2012 at 3:17 PM, Norman Cliff May nor...@gmail.com wrote:
The lookup names have to
Hello,
I need IF formula in attached sheet. IF Column C0, Then Pre-Ops otherwise
Construction, IF Column F0, then Commissioning otherwise Pre-Ops IF
Column I0, then Operation otherwise Commissioning.
Please help. I am stuck now.
Regards,
Imran
--
FORUM RULES (986+ members already BANNED for
On Tue, Jul 10, 2012 at 3:55 PM, Deba Ranjan drdeva...@gmail.com wrote:
PFA, might it will help you.
Thanks Regards,
*Deba Ranjan P*
On Tue, Jul 10, 2012 at 3:35 PM, Imran khan ikha...@gmail.com wrote:
Hello,
I need IF formula in attached sheet. IF Column C0, Then Pre-Ops
Hello Khan,
Please check the file attached , hope it helps.
On Tuesday, July 10, 2012 1:05:17 PM UTC+3, Imran khan wrote:
Hello,
I need IF formula in attached sheet. IF Column C0, Then Pre-Ops otherwise
Construction, IF Column F0, then Commissioning otherwise Pre-Ops IF
Column I0,
Hello ,
In case you have to files .xls and .xlsx you have to make formula with
Insert Function ( ALT + I + F ).
instead of write =vlookup or =lookup
give it a try.
On Tuesday, July 10, 2012 12:23:47 PM UTC+3, Bhaity wrote:
Hi Experts,
i am getting error in vlookups in finding the
Thanks Ji,but could you please solve in the sheet.
Thanks Regards,
*Deba Ranjan P*
On Tue, Jul 10, 2012 at 4:08 PM, CoRe neculae.vale...@gmail.com wrote:
Hello ,
In case you have to files .xls and .xlsx you have to make formula with
Insert Function ( ALT + I + F ).
instead of
Dear all,
This is very useful information and I have been trying to use it at my
work. Since, I am in beginner phase can you please teach me as to how to do
it from the scratch?
Thank you all,
Sunita
On Tue, Jul 10, 2012 at 12:02 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Amit,
Hi Sunita,
Please find below link, hope it will you to explain How can use Hotkey In
VBA
http://www.excely.com/excel-vba/assign-hotkey-to-smartdel-macro.shtml
http://www.mrexcel.com/archive/VBA/3401b.html
On Tue, Jul 10, 2012 at 4:22 PM, सुनिता पौडेल tosune...@gmail.com wrote:
Dear all,
Thank you Noorain.
I hope can look at you if stuck in there.
Thank you once again.
Sunita
On Tue, Jul 10, 2012 at 5:05 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Hi Sunita,
Please find below link, hope it will you to explain How can use Hotkey In
VBA
Hi Deba,
Anil Solution is nice
you can also use below formula without using Ctrl+shfit+Enter
=LOOKUP(2,1/(SUBSTITUTE(SalarySheet!$A$2:$A$146, ,)=SUBSTITUTE($B2,
,)),SalarySheet!$D$2:$D$146)
On Tue, Jul 10, 2012 at 4:56 PM, Anil Gawli gawlianil8...@gmail.com wrote:
Dear devaran,deba,neculae
Sub listfiles()
For i = 1 To Sheets.Count
Cells(i, 1) = Sheets(i).Name
Next
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amitkmr
Sent: Tuesday, July 10, 2012 12:41 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ no of sheets in a
Hi All,
I got the below coding from some other sites.. but while executing this
macro, i got error messages and i can't solve this coding issue. Please
help me to get resolve or any new coding to split tif images thru excel vba
macro.
*
Option Explicit
Dim ImageFile
NEI
Not enough information
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Excel Vba
Sent: Tuesday, July 10, 2012 8:42 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query - AutoNumber
Hi Group,
I am trying to get a automatically generate a
can u give a idea
On Tue, Jul 10, 2012 at 7:52 PM, dguillett1 dguille...@gmail.com wrote:
NEI
Not enough information
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
*From:* Excel Vba excelvba.lear...@gmail.com
*Sent:* Tuesday, July 10, 2012 8:42 AM
Sorry, not enough info.
WHERE do you have the numbers?
how do you tell what the last number used was?
are the numbers actual NUMBERS or are they ALPHAnumeric? (like: A123456)
For instance,
if the numbers are all in column A,
AND THEY'RE NUMERIC
then you can use:
NextNo =
If you are saying you want the first word in a string then
=LEFT(D10,FIND( ,D10))
or
Sub fw()
For i = 2 To Cells(Rows.Count, 2).End(xlUp).Row
Cells(i, c).Value = Left(Cells(i, d), InStr(1, Cells(i, d), ))
Next i
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
Thnaks Paul.
-
On Tue, Jul 10, 2012 at 8:00 PM, Paul Schreiner schreiner_p...@att.netwrote:
Sorry, not enough info.
WHERE do you have the numbers?
how do you tell what the last number used was?
are the numbers actual NUMBERS or are they ALPHAnumeric? (like:
Hi Muneer,
Please see the attachment.
regards
Prince dubey.
On Tuesday, July 10, 2012 7:55:34 PM UTC+5:30, Mohammed Muneer wrote:
Hi! Everybody,
Dear Group,
I want to extract a word from the sentence in cell beside.
Plz, find the attachment………
Hi Ann,
Can you please explain bit more about your issue.As we are not able to
understand your Issue.
Do you want to copy data from active cell or anything else ?
regards
Prince dubey.
On Tuesday, July 10, 2012 3:21:50 PM UTC+5:30, an wrote:
Dear experts,
please help to do view code in
Which word you want to extract?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mohammed Muneer
Sent: 10 July 2012 7:56
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Extracting a word
Hi All,
can you help me on this. I have quite large excel file, because there is a lot
of calculation, I'd like to switch off excel calculation and when I'll be
closing file schitch on calculation. I mean by macro (manually I know how to do
this :) )
thanks a lot
Pawel
--
FORUM RULES
Use this line in your macro :-
Application.Calculation=xlCalculationManual
Warm Regards
Ankur Aggarwal
91-8010614628
Analyst
Mckinsey Knowledge Center
Mckinsey Co.
From: pawel lupinski lupins...@yahoo.com
To: excel-macros@googlegroups.com
Dear Don,
Superb Innovative.
Keep it up!
Both code and formula good.
Experience is the mother of Knowledge
Whenever I receive a help from u people, in a fraction of seconds I feel
myself why I can't do this magic by myself.
But I keep trying to do some until I get an idea.
But
Hi Shai,
For First Word:-
=IFERROR(LEFT(G2,FIND( ,G2,1)),G2)
For Second:-
=IFERROR(LEFT(RIGHT(G2,LEN(G2)-FIND( ,G2,1)),FIND(
,RIGHT(G2,LEN(G2)-FIND( ,G2,1,)
For third:-
=IFERROR(IF(LEN(C2F2)+2=LEN(G2),””,MID(G2,LEN(C2)+7,LEN(G2)-LEN(C2F2)-7)),)
For Forth:-
Wow! Superb here r the efforts.
Regards,
Muneer,
CC
Muneer Ji,
PFA.
For First Word:-
=IFERROR(LEFT(G2,FIND( ,G2,1)),G2)
For Second:-
=IFERROR(LEFT(RIGHT(G2,LEN(G2)-FIND( ,G2,1)),FIND(
,RIGHT(G2,LEN(G2)-FIND( ,G2,1,)
For third:-
28 matches
Mail list logo