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 su
This module can help u out in sending email by outlook,
I have considered data is been in "sheet1" and email id in Col"A"
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 ou
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 past
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
http://w
Please let us stick to topics on excel in this forum.
Thanks
Ashish
On Mon, Jan 5, 2009 at 4:27 PM, Deepa Bharti 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 c
I was hoping to have them individually fill cells on sheet 1.
Galway
On Jan 1, 7:16 pm, Paul Schreiner 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 1.
> Or. you could
I think you will like it.
Please accept or reject this invitation by clicking below:
http://www.bebo.com/in/8409672181a119708434b135
..
Please do not reply directly to this email.
This email was sent to you at the direct req
Hi Shay,
Here is the solution. just change the " smtp..com" which is in the
CDO_Mail_Small_Text procedure with the appropriate one.
let me know if you have any queries.
regards
Mugundan
Office VBA Trainer
Sub send_mail()
Dim lngI As Long
Dim
> I wonder if you can help out an absolute novice when it comes to excel
> macros.
> My girlfriend has sent me some homework as she has to work today and I am
> at home trying to read up on Excel Macros 2003...
> She needs to be able to look through each of the day cells in her excel
> calen
I'm looking to use a string for the password protection of the sheet
and workbook. I have a button that prompts the user to change the
password if necessary, but the string is empty in other parts of the
code.
' Initialization coding
Private Sub Worksheet_Activate()
Dim PW As String
PW =
Thanks a lot Mr. Tom, for the nice file for the Macro.
Could you also provide me the file for Access Macro's as I need to do with
all these.
I know this is not the group for Access but still if you provide me that I
would be highly obliged.
Thanks and regards,
=
- k...@m@l' g...@
Hi Keyur,
Yes, you can select the column which you want to hide and to go to Format
Menu --> Column --> Hide.
On Mon, Jan 5, 2009 at 4:56 PM, Keyur Shah wrote:
> 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 m
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 wrote:
>
> This module can help u out in sending email by outlook,
> I have considered data is been in "sheet1" and email id in Col"A"
> s
Do you have an example of the Calendar? Describe its format in more detail.
On Mon, Jan 5, 2009 at 5:18 AM, Joe wrote:
>
> > I wonder if you can help out an absolute novice when it comes to excel
> > macros.
> > My girlfriend has sent me some homework as she has to work today and I am
> > a
Dear All
I am creating a dashboard to display data to senior managers on how we
are performing at any one time. The vechicle used to display this
data has to be easily accessible, free and only to be controlled by me
(a non-IT person!). Therefore, powerpoint has been selected as the
vechicle to
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 dela
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 tutorials
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, bu
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 lic
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 k
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 to
24 matches
Mail list logo