in editor press F2 you will get all
On Tue, Feb 15, 2011 at 11:13 AM, Jeff wrote:
> I'm starting to write some code in VB (may end up as vbscript, or vb) and
> would like to understand how the proper way to get all the internal
> constants declared? A couple of examples might include xlDayof
How I can load a image from a url using the LoadPicture function in
userform.
Regards,
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
I'm starting to write some code in VB (may end up as vbscript, or vb) and
would like to understand how the proper way to get all the internal
constants declared? A couple of examples might include xlDayofWeek or
vbCRLF. Do I include a header file that defines them for me?
Thank for your insi
Hi Paul,
I have also noticed that after deleting and creating sheets, the Sheet numbers
are out of order, and can be missing altogether. ie in a workbook of 7 sheets,
one of them may be Sheet(11), while sheets 8 and 9 are not present at all.
So, my question is, why does this line of code (Sheets
"Array" and "Variant" is like saying
Is this apple Red or Peeled?
I think what you really want to know is if
Dim ABC
declares a single value variable or array.
Because, without defining a type, the default
data type is Variant. That means that:
Dim ABC
is the same as:
Dim ABC as Variant
and
Di
In your VBA Object Explorer, you'll see
Sheet1(Name1)
Sheet2(Name2)
Sheet3(Name3)
If you delete the sheet named "Name2", create a new sheet, and call the NEW
sheet "Name2"
It won't be:
Sheet2(Name2), it'll be:
Sheet4(Name2).
So the LIST will be:
Sheet1(Name1)
Sheet3(Name3)
Sheet4(Name4)
in VBA
On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad wrote:
>
> Hi all experts,
>
> Please resolve my query by formula. sheet attached.
>
> Regards,
>
> Aamir Shahzad
>
> --
>
> --
> Some important links for excel users:
>
also pls tell me if dim abc is array then
does dim abc is equal to dim abc() ?
From: hanumant shinde
To: excel macros
Sent: Tue, 15 February, 2011 1:38:21 AM
Subject: Array or Variant ???
if i seclare variable like this
dim abc
is this array or variant o
Hi,
we are using excel 2010. I use sheets(2) in my code and it was working
fine (since this was the 2nd tab in my file till I manually added
another sheet and I moved this 3rd sheet betwenn sheet 1 and 2 so now
3rd sheet is in 2nd order in my file(2nd tab). I have renamed the tabs
ofcourse and the
if i seclare variable like this
dim abc
is this array or variant or something else. if array the what data type
i have code in my office (somebody else's code) where variables are declared
like this and i thought these are variants but after going through paul's mail
chain i guess those are ar
Hi Guys,
Pls check attached excel sheet.
I have data in across 2 columns which i want move in one row through macro,
is it possible?
actually the data is extracted from access database so if its poss through
macro then i can process in access rather trolling it through excel.
appreciate your ef
Hi Team,
I need a graphs in the attached file and need a formula to add the total
time spend.
Any quick help will be appreciated.
Regards,
Vin
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Hi all experts,
Please resolve my query by formula. sheet attached.
Regards,
Aamir Shahzad
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/excelda
Check if mine is ok for you
Thanks,
Sundarvelan,
9600160150
On Mon, Feb 14, 2011 at 8:08 PM, ashish koul wrote:
> see if it helps
>
>
> On Mon, Feb 14, 2011 at 5:15 PM, Nemi Gandhi wrote:
>
>> attached herewith rashi querry sheet. Please provide me formula and help.
>>
>> --
>> Nemi Gandhi
>>
Yes exactly like you demonstrated :), sorry for my poor explanation, i can
do it if i separate first to columns, but can it be done all at the same
time?
2011/2/14 Paul Schreiner
> I'm still not sure what you're trying to do.
> Your original data looked something like:
> A;11;21;31;1
> B;12;22;
Hi Paul
Thanks for reply, still I have a problem in it I copy the code u
suggested but it updated the sheet "JANUARY" only. why please check
once more.
Regards
Rajesh kainikkara
On 2/14/11, Paul Schreiner wrote:
> This isn't EXACTLY the same problem.
> In your original post, you were selecting
This isn't EXACTLY the same problem.
In your original post, you were selecting a range from "EMP REG"
and then selecting a monthly sheet and running an external macro called
Import_fromregister.
In THIS file, all you're doing is copying range B2-O200 of sheet "ITEM MASTER"
to each sheet.
This sh
start date in a1
and end date in a2
no of sundays =INT(((A2-A1)-NETWORKDAYS(A1,A2))/2)+1
On Mon, Feb 14, 2011 at 6:04 PM, N Pradhan wrote:
> Dear Sir,
>
> Formula required for nos. of sundays between two days.
> e.g. if an employee has joined on 18/7/2010, how many sundays between
> 18/7/2010
see if it helps
On Mon, Feb 14, 2011 at 5:15 PM, Nemi Gandhi wrote:
> attached herewith rashi querry sheet. Please provide me formula and help.
>
> --
> Nemi Gandhi
> 98204 92963
>
> --
>
> --
> Some important links
Dear Sir,
Formula required for nos. of sundays between two days.
e.g. if an employee has joined on 18/7/2010, how many sundays between 18/7/2010
and 31/01/2011.
Thanks & Regards.
--
--
Some important links for exce
Hello
Whan you import data from SQL you have the query wizard and just
before it ends importing data form SQL to excel
it asks you to go directly to excel or EDIT IN MICROSOFT QUERY , if
you choose editing in microsoft query you can specify and add terms
where you specify which data from which tab
attached herewith rashi querry sheet. Please provide me formula and help.
--
Nemi Gandhi
98204 92963
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.co
This is "Off Topic" (I put "OT" in the title)
Technically, to keep from "hijacking" a thread
if you wish to continue this discussion,
we ought to start a separate topic
Or take it "off-line" (email between the two of us)
However, since others might be interested, I'll mention it here...
You CAN
Let me know if you need any help.
Paul
From: Rajesh K R
To: excel-macros@googlegroups.com
Sent: Sun, February 13, 2011 7:08:16 AM
Subject: Re: $$Excel-Macros$$ Insert raw based on condition in a range
Hi Paul
Thanks for the code, I want to get the copied dat
I'm still not sure what you're trying to do.
Your original data looked something like:
A;11;21;31;1
B;12;22;32;2
C;13;23;33;3
D;14;24;34;4
E;15;25;35;5
F;16;26;36;6
G;17;27;37;7
H;18;28;38;8
I;19;29;39;9
You split it into separate columns, using ";" as a delimeter..
Now you're saying that you wan
I'm not sure what your Import_fromregister macro is doing,
so I'm not sure whether the sheet name needs to be a public variable.
But this should loop through the months:
Sub Update_sheets_All()
Dim M, ShtName
For M = 1 To 12
ShtName = Format(M & "/1/2011", "")
If Shee
use this code in sheet 1
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Target.Column = 1 And Target.Row = 3 Then
Sheets(2).Activate
Sheets(2).Cells(2, 1).Select
End If
End Sub
On Mon, Feb 14, 2011 at 12:48 PM, rashid memon wrote:
> please Provide Macro Co
please Provide Macro Code...
File is Attached...
--
Looking forward to receive your kind attention.
Thanks & Best Regards
M.Rashid.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tri
Dear Jitender,
Use the mail merge option in the word
On Sat, Feb 12, 2011 at 9:38 PM, Jitender kumar wrote:
> Dear Excel Gurus,
>
> Urgent help required from your part, Plz help me on the file attached.
> Problem in file
>
> Thanks in advance
>
> Regards
>
> Jitender
>
> --
>
>
29 matches
Mail list logo
