Dear friends
Please suggest me book for Excel and VBA coding
thank you in advance
from
Khalid khan
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tut
I have a sheet that refreshes from a web query. I wanted to
automatically do some formatting after I refresh the data but no
commands are executed after the refresh. Interestingly if I step
throught the Macro in the VBA editor using F8 it works fine. The code
is below
Cells.Select
Select
I was able to reproduce your problem and can offer a solution, however
regrettably without being able to explain why it works. Replace the
section of your code that deals with the unprotecting, copying and
pasting, and re-protecting:
Worksheets("Computation").Range("compute").Copy
You are welcome!
On Oct 28, 7:06 pm, OSAVentures Calamba wrote:
> @Rolf ... Thank you very much... You were a BIG BROTHER to me, teaching me
> in detailed patience how to make my first steps in walking to macros. I
> tested my codes with ALL your suggestions and it went fine. May you be
> bless
Good morning all,
I have a problem with the conditional formating in graph. Can we able to
change the color setting in the graph with the changes in data.
The attached file in Ms excel 2007. Will it be possible in Excel 2003 also.
--
Thanks in advance
Ajith Kumar P K
--~--~-~--~~-
Hey guys,
Is it possible to merge this two user defined functions, as one function is
for getting the results from the left side of the data range, this function
excepts negative value in place of column index *(Vlookup(E1,D1:D100,-3,0).*
*Code for this function is as follows:*
Function VLOOKNEW
Hello Everyone,
I have a question about counting rows in a spread sheet. I thought the
answer to this would be straight forward but I can't seem to get it to
work the way I want. I would like to count the rows on a sheet where
one cell has a value (a client number) and where another cell is blank
Hi,
The link below lists members in decending order 50 per page. Is there
anyway to "capture" the web address of next page of data with regards
to the address below until the last page is encountered ?
http://contests.covers.com/Handicapping/topHandicappers.aspx?sportid=1
As it is now, I have t
Hi
I have an excel sheet (attached) having a table with 3 columns, "Entry
Number", "Party Name" and "Amount"
In the result sheet I have:
1) In the row first row: selected values from "Party Name"
2) In the first column: selected values from "Party Name" (though from the
same field as the first
No, because VBA executes "linearly".
meaning that if the command: Select Case A-B
is valid at the time it executes,
then changes made afterward do not affect
previous statements.
(be sure you put some kind of loop counter
on you Do..Loop to make sure that it doesn't
get stuck in an infinite loop..
The problem is with the LOCATION of your UDF.
VBA itself will look in Personal.xls and Personal.xlsb,
but the Excel worksheet is NOT.
If you had a sheet called "Sheet1" and another called "Sheet2",
and you wanted the cell B4 of Sheet1 to display the contents
of cell C10 of Sheet2, you couldn't use
Is there a proble changing the test value inside the case code?
Example
Do
Select A-B
Case <0
New A
Case 0
New A
New B
Case>0
New B
End select
Loop
--~--~-~--~~~---~--~~
--
Some impor
Is there a problem changing the test value in the case code?
Example
Do
Select A-B
Case <0
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(V
Dear friends,
here is another useful user defined function. but returns error #NAME?.
please giv the solution.
Function VLOOKUPNTH(lookup_value, table_array As Range, _
col_index_num As Integer, nth_value)
Dim nRow As Long
Dim nVal As Integer
Dim bFound As Boolean
VLOOKUPNTH = "N
*Dear friends,*
*I HAVE FOUND THIS USER DEFINED VLOOKUP FUNCTION WHICH FIND THE RESULT FROM
LEFT SIDE. *
*CAN ANYONE HELP WITH THIS USER DEFINED FUNCTION, DONT KNOW WHY THIS IS NOT
WORKING WHEN I PASTE THIS CODE IN MODULE OF MY PERSONAL WORKBOOK. IT IS
GIVING ERROR #NAME?*
Function VLOOKNEW(look
Mahesh,
See the attachment.
Thanks & regards,
|| Mudassar Ramzan | WLL -- 061- 814-3999 | Cell -- 0321 7325277 |E-Mail:
busybird1...@gmail.com | Web: http://johnplayer78.sitesled.com ||
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of
Hi
See attached file
2009/10/29 Mahesh
> Dear Frineds,
>
> Please help me to solve the problem in attached sheet.
>
>
>
>
> --
> With Love,
> Mahesh Bisht
>
> >
>
--
Hemant Hegde
--~--~-~--~~~---~--~~
I need to calculate in interest excel sheet could any one help me with?
Its like insurance calculation method, user will pay premium yearly basis,
Period 20 years
Conditions
1.Bonus will be calculated from 4th year onwards
2. 1 year -30%, 2nd year 10%, 3 year -10% will be deduc
Sorry.
There is no such thing as "a simple code"
to copy PDF image to Excel.
The problem is that the PDf file is an IMAGE
format, where Excel is DATA.
You might as well say: "I took a picture
with my cell phone and now I want to put it
in Excel".
You can BUY software that can look at
the image
Dear Frineds,
Please help me to solve the problem in attached sheet.
--
With Love,
Mahesh Bisht
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tut
Hi All,
I'm searching for VBA code wherein, if I click the macro button
(form), the content of the entire row (or pre-defined range data) has
to be mailed to the concerned person.
for example.
Sl NO.Name Sub Status
Result
1. Srinivasa Math
Hello Excel Geeks,
I want a simple code to cody data from Pdf and paste it in a excel
sheet.
So any body out there to help me out
Thanks
Santosh Mathew
--~--~-~--~~~---~--~~
--
Some i
22 matches
Mail list logo
