when you Dim a variable WITHIN a sub, it is known as a local variable,
and only has value WITHIN the sub.
If you use:
Option Explicit
before your subs, you'll find that your PW variable is not defined in the other
subs.
What you need to do is declare the variable as Global BEFORE your subs.
This module can help u out in sending email by outlook,
I have considered data is been in sheet1 and email id in ColA
subject in col C
add body of the email as u want in space provided.
This will send all the emails through your current profile itself,
whichever would be activated in your outlook
Hi
I created a file from excel that our people use daily. now i want to make a
page with in column a down 365 qoauts or bible verses. the code to get to
either print or display this i got figured out.
what i need though is the qouats. ;-)
any one know where i can download/copy
hi,
Can anybody guide me how to hide data in column sothat no one can visible
and i want to lock sheet that mouse pointer move only selected column only.
--
Keyur Shah
(M) 98259 28073
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
Please let us stick to topics on excel in this forum.
Thanks
Ashish
On Mon, Jan 5, 2009 at 4:27 PM, Deepa Bharti deepa.bha...@gmail.com wrote:
I think you will like it.
Please accept or reject this invitation by clicking below:
http://www.bebo.com/in/8409672181a119708434b135
Along the same lines, I am trying to email from Excel, but I only want
to email only from the current row after I right click on cell 13 in
that particular row. Here is just a snippet of what I found that uses
a For Next loop, but I only want the selected row, not all 8200+ rows.
How can this be
I was hoping to have them individually fill cells on sheet 1.
Galway
On Jan 1, 7:16 pm, Paul Schreiner schreiner_p...@att.net wrote:
How do you want to return the results?
It's a simple matter to create a loop that looks through column A and
for matching values, add the column B data to sheet
Girish,
I am facing an error as User- defined type not defined for all
Dims.
Regards,
Shay
On Mon, Jan 5, 2009 at 5:42 PM, girishkr...@gmail.com girishkr...@gmail.com
wrote:
This module can help u out in sending email by outlook,
I have considered data is been in sheet1 and
Dave:
Thanks for your response. I tried this solution but ran into
performance issues. There are 10 columns that hold values and
sometimes hundreds of rows of data. There are also approx. 20,000
valid ICD9 codes that this is validating against. Moving around the
spreadsheet caused serious
Hi,
Can anybody extend ur knowledge for me.
How to connect 2 or more systems using macro. Example connecting Excel
and Mainframe, or Excel and Oracle, Excel and Peoplesoft etc...
Thanks
Rgds/Karthik.
--~--~-~--~~~---~--~~
Visit the blog to download Excel
Hello y'all!, i need some minor help with Excel 03, i have a image in
cell G12, i want to assign a macro to it that would give me the
location of that image within the spreadsheet, so in this case, it
should pop up with G12 when i click on the image. I know how to
assign a macro to a picture, but
Hello
First, sorry for my English. I'm Brazilian and not used to do that.
I'm following a manual to create system to use in a library. This manual ask
to insert the msflexgrid, but when I try to do that, excel answer that is
not possible to create the control because it is not correctly
go to tools - options - calculation and and turn Manual calculation on.
_
There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things
Is there a way to retrieve domain name using vba...? I need this to make sure
that my vba tool will run only within the network of my compay.
Thanks and Regards,
Alokeshwar Tiwary
_
There are known
Hi Rob,
Yeah, sorry about that. Countif is pretty slow when there's lots of data. By
the way, a macro will be slower, but has the distinct advantage that you can
run it only when convenient.
Just looking at your code, I see that you are using the Cells thingy.
When using Cells, you cant refer
15 matches
Mail list logo