Assuming that you know to write macro, try the function Instr
On Jun 13, 2:01 am, Søren wrote:
> I have a number of lists containing names of proteins. I need to check
> if these lists contain words from some other lists. Normally easy, but
> I should get a true value, even if only a part of the
I have done a new code for you, check this out
Sub find_text()
Dim ws As Worksheet
Dim startrow As Integer
Dim startcol As Integer
Dim endrow As Integer
Dim endcol As Integer
Dim find_text As String
Dim pasterow As Integer
Dim cell_address As String
pasterow = 1
find_text = InputBox("Please enter
I have tried to convert this for you... just check this out
Sub interest(Principle As Double, rate As Double, days As Integer)
Dim i As Integer
Dim x As Double
Dim y As Double
Dim z As Integer
Dim j As Integer
Dim P1 As Double
Dim d1 As Integer
Dim interest1 As Double
Dim interest2 As Double
x =
Dear Ashish
Which version of Excel you are using?
Yahya
On Fri, Jun 12, 2009 at 12:44 PM, Ashish Pradhan wrote:
>
> Hi
>
> I have downloaded some tables in excel using Copy/Paste Function (Not
> the "Get External Data" feature). Unfortunately, there are a lot of
> links in the excel cells.
>
Hi Fabio, I'm using the Excel 2007 version
-insert -...graphics...
I do know the type of graphic why you make, but i need to make with mean and
variance in same graphic
regards
Jen
2009/6/12 Fabio Lemos
> You will need to add error bars with custom values...
>
> see attached f
I have a number of lists containing names of proteins. I need to check
if these lists contain words from some other lists. Normally easy, but
I should get a true value, even if only a part of the cell equals a
word from the other list. Like in the example below:
MASTER LIST:
abcd
defg
cdef
efgh
I would like to reformat imported csv data into a custom report. The
imported data has a unique record in each row. There is one column
that has a value for 'fabric' of S, F or L for each record. I would
like to create a macro that would take all of the records with a
fabric type of S and copy
Hi
I am ruchi gaba
I hv 2 probs
1- can i open the pdf file in word without using software like pdf tranformer?
2- i hv interview on monday and VBA, MS Access ,MS excel is required
in the software co. i hv dont all this in my course but the probs is
my concepts are not clear specially in VBA wat
Hi everyone,
I am having trouble creating a simple table in Access with a combo box
and retrieving the information into two text boxes. Here it is what I
have done:
1. imported a Excel file into Access
2. Created a table with the Excel Spreadsheet
3. Created a query with three columns that I nee
descending order could have been done by using small function,
=SMALL($B$2:$B$38,COUNTA($B$2:B2))
Ritesh
On 6/12/09, Ramesh Katta wrote:
>
>
> Hi Amitabh
>
> Thank you very much.
>
> Regards
> Ramesh
>
> On Fri, Jun 12, 2009 at 1:59 AM, Amitabh Bose
> wrote:
> >
> > Hi Ramesh,
> >
> > I have at
Hi Amitabh
Thank you very much.
Regards
Ramesh
On Fri, Jun 12, 2009 at 1:59 AM, Amitabh Bose wrote:
>
> Hi Ramesh,
>
> I have attached the spreadsheet and solved the second issue with regard to
> the Date() function. and this is on the sheet named 'Date formats'. There
> may be better ways of d
Dear Ramesh,
Thanks a ton..!!
Dilipandey
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Fri, Jun 12, 2009 at 5:50 PM, Ramesh Katta wrote:
>
> Hi Dilip,
>
> Cleared my doubt with your solution. Thank you ve
Hey guys thanks
but ..I copy the code into new sheet, and it works perfect too.. it is just
in that original sheet, it only works for 0 ,but rest of them..
please open the sheet and take a look..
On Fri, Jun 12, 2009 at 3:13 PM, Fabio Lemos wrote:
> I have tested and it works for me
> H
Hi,
I'm making a macro to search words in the workbook
it creates a sheet "FindWord" with a link for the word ... as the
example:
Occurences of: test
Location Cell Text
Sheet1!F20test
Sheet2!D50test
Sheet5!C5 test
I notice that the function is with
HI Ashish,
Thanks for reply.
I think you are right.There is no inbuilt feature to accomplish this.
Even I can't use worksheet_chagne() to accomplish this requirement
because other requirement is affected
Finally I am ignoring this requirement.
Thanks and regards,
Harish
--~--~
Dear All,
Kindly please provide me a macro code for the below algorithm which is used
to calculate compound interest. Also i would appreciate if you can provide
me details on how to use that macro.
Int_Rate(Principle p, ROI r,Days d)
{
int i;
if(r = x && r <= y && d<= 15)
{
Hi Dave,
I had doubt on large() and date() functions now I got the solution
from Mr. Dilip.
Thanks&Regards
Ramesh
On Fri, Jun 12, 2009 at 5:26 AM, Dave
Bonallack wrote:
> Hi,
> Have a look at the attached and see if it does what you want.
> Regards - Dave.
>
>> Dear members,
>>
>> Please go thr
Hi Dilip,
Cleared my doubt with your solution. Thank you very much.
Regards
Ramesh
On Fri, Jun 12, 2009 at 2:38 AM, Dilip Pandey wrote:
> Dear Ramesh,
>
> Please find the solved workbook attached herewith and I must say that "Date"
> part is a good one. Thanks.
> Dilipandey
> --
> DILIP KUMAR
Hi Vincent,
I tried your macro code in your workbook and it did hide/unhide
columns G:K for me. Perhaps there's an extra step required for me to
replicate the problem? (I'm using Excel 2007 btw)
If you place a breakpoint in your Worksheet_Change code, does the
compiler reach it? This would conf
Try this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value = 0 Then
MsgBox "000"
'Sheets("Parametervalg").Select
Columns("G:K").EntireColumn.Hidden = True
End If
If Target.Value = 1 Then
MsgBox "111"
Columns("G:K").EntireColumn.Hidden = False
End If
End Sub
Hi
I have downloaded some tables in excel using Copy/Paste Function (Not
the "Get External Data" feature). Unfortunately, there are a lot of
links in the excel cells.
Is there any way to remove all hyperlinks from an excel file
(workbook) instead of doing it manually one cell at a time?
Appreci
Hi Members,
When working with mutli-level category axes I've noticed that Excel
2007
incorrectly displays the axis when there are more than 100 rows of
data
included in the chart. Many of the labels are not displayed.
The same thing does not happen in 2003. Even if you save that file
down to
xl
Hi Ramesh,
I have attached the spreadsheet and solved the second issue with regard to the
Date() function. and this is on the sheet named 'Date formats'. There may be
better ways of doing this but this is the method which came to mind first.
I was not clear on what you exactly wanted do
Hi Satish,
I had the chance to look at this further this morning. The following
code seems to do the trick of pasting one workbook's data under
another.
All the best,
Chris
www.Technicana.com
Sub CombineFiles()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
vMaster = Ac
Hi All,
Baloo is facing some issues with the text to column. As in the attached text
file.
I am also pasting his initial mail for your reference.
Kindly help him, I would be too busy to look into these for a couple of
days.
Original Mail:
May be this is very simple for you experts . I am unable
Thanks Dilip,
Infact I missed the green part too.. in the custom format...
Regards,
Aindril
On Fri, Jun 12, 2009 at 4:22 PM, Dilip Pandey wrote:
> Hi Ramesh / Anidril,
>
> Just realised that I forgot the Green part in the custom format. Use
> following format to match up the requirement:-
>
>
I have tested and it works for me
Have you turnedmacros on?
2009/6/12 zheng yu
> Hi All,
>
>I got this request from a colleague who is asking me to find out the
> problem assuming i am the best VBA and C++ programmer here.;P
>
>But I can't fix it. I can create a new sheet with same
You will need to add error bars with custom values...
see attached file...
If you need help, please inform wich excel version do you use...
2009/6/12 jen
>
> Dear member,
> I have a question . The question is how
> to make a graph….I do know your name or kind
> For example I have range th
Hi,
For the first problenm, I suggest you to use the array formula see
attached
For the second I did it in two ways See the one wich fits better your
needs. The first way I converted the number to date and applyed custom
formats, the other way i used the date to extract the information.
U can use the custom number format:
see attached file...
2009/6/11 Ramesh Katta
> Dear member,
>
> I have a question which was asked in interview. The question is how
> to apply color to range with using conditional formatting.
>
> For example i have range suppose a1:a20 containing negative an
Well there's a couple of things that *I* see...
#1... "Total" is 5 characters, not 4...
so Left(ActiveCell.Value, 4) = "Total" will never be true!!!
Also, you need to learn to run the debugger and 'step through'
your code.
You can then go one line at a time and see what is actually
happening.
Hi,
Have a look at the attached and see if it does what you want.
Regards - Dave.
> Dear members,
>
> Please go through the attached document for questions I asked
>
>
> Regards
> Ramesh
>
_
Get the latest news, goss and sport
Hi Ramesh,
You need to freeze the data range and them move down.
=countif($a$2:$a$10,"M").
Use F4 key in formula to freeze (Lock) the cell references.
Thanks,
Dilipandey
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi -
Hi Jenny,
Chart is done and is there in the attached workbook. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Fri, Jun 12, 2009 at 9:34 AM, jenny Hanson wrote:
> Dear member,
>
> I have a question
*Dear Ramesh,*
Please find the solved workbook attached herewith and I must say that "Date"
part is a good one. Thanks.
Dilipandey
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Fri, Jun 12, 2009 at 11:53 AM
Hi Ramesh / Anidril,
Just realised that I forgot the Green part in the custom format. Use
following format to match up the requirement:-
[Green]0.00%;[Red]0.00%
Note:- Solved excel workbook is also attached herewith.
Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 981092974
Thanks Aindril,
I was little occupied and that's why not able to answer this in-time.
Thanks.
Ruchi... I believe this has cleared your doubts. If you still feel some
confusion, then please revert back. Thanks.
Dilipandey
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
di
Hi Jen,
I have attached a file with the points plotted for both the mean and variance.
I am not sure which version of MS Excel you are using. The version of the file
attached is on MS Excel 2007 and the steps to construct the graph is as follows:
1. Insert - Choose chart type (Eg column
Dear members,
Please go through the attached document for questions I asked
Regards
Ramesh
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials
You need to copy the data to excel. The format of your data is not correct.
Like, you will need to change 2.147.523 ---> 2147.523.
In excel it is very easy to plot the data.
Akhilesh Kumar Karna
On Fri, Jun 12, 2009 at 1:04 PM, jenny Hanson wrote:
> Dear member,
>
> I have a question . The qu
Dear Andy,
Thanks a lot.
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Aindril De
Sent: Friday, June 12, 2009 5:38 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: HELP ON CHART PREPARATION
Dear Vivek,
This can be done using P
Mr. Chris Spicer
Thank you very much for your immediate reply, i tried with the quick fix
solution u suggested is not leading to correct merging. Can you plz clarify
if the 'sheet.usedrange' should replace that line or insert in some other
place. To be frank am not used to this visual basic.
On Th
42 matches
Mail list logo