Hi,
This just means that the code has paused for some reason (perhaps because you
asked it to, or perhaps it has a mind of its own). You just need to click the
Reset button on the VBA toolbar. This will allow other code to run. Basically,
you can only run one code at a time. When a code is in
Hi Adam,
If you are using Excel 2007, This would be a task for some keystrokes
You need to :
1. Copy the data and transpose entire data in a single row.
2. Copy the entire row and paste the data in a notepad.
3. In the notepad, copy blank space between e-mail IDs.
4. Press Ctrl+H and Paste
Hi,
Here's my contribution
If you have N/A or any other data which is commonly filled in various cells
of a work book and you would like to replace all of them with a blank or any
other character, say, Y.
1. Press Ctrl + F
2. Type the text which you wish to find
3. Click on
Hi Dear,
Please find the same mentioned below.
1274-1890-1528
*Unfeigned Regards
Manoj S Negi
Miles miles to go before I sleep*
*¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.·´ Smiling!
`·.¸.·´
(¨`·.·´¨) (¨`·.·´¨)
`·.¸(¨`·.·´¨)¸.·´
`·.¸.·«*:·.
.·:*
*:·.
*«*:·.
.·:*
*:·.
*On Mon, Jun 22, 2009
Other possibility is that when you have opened the workbook you select to
disable macros or the security level has disabled it automatically
Go to Tools Macro Secority...
2009/6/23 Dave Bonallack davebonall...@hotmail.com
Hi,
This just means that the code has paused for some reason
Separating the number in A2 into digits, so that each of cells B2:G2
will contain one digit.
Solution:
Using the MID and COLUMN functions, as follows:
=MID($A2,COLUMN()-1,1)
Separating a Number Into Digits
ajaY :)
On Jun 22, 5:51 pm, mageshwaran jayaraman macwa...@yahoo.co.in
wrote:
Hi,
Suppose I name each of a set of columns. I can use those names in a
formula provided the formula refers only to cells in the current row.
But I haven't been able to figure out how to reference rows other than
current row using column names. This is probably glaringly obvious,
but I've been unable
Thank you all very much. Problem solved.
Thank you very much again.
Adam
On Jun 23, 4:08 am, Upendra Singh upendrasinghsen...@gmail.com
wrote:
Hi Adam,
If you are using Excel 2007, This would be a task for some keystrokes
You need to :
1. Copy the data and transpose entire data in a
hi All, thought this would be easy but I get:
Run-time error 1004. You cannot use this macro on a protected
sheet
Anyone knows what's going on re. my code below? Just the protecting
works but I would like to hide all formula's and then I get the error
though my sheets are not protected.
DEAR ALL,
CAN ANY ONE HELP ME OF FINDING OF ALL LINKED CELLS IN MAIN SHEES JUST BY
CLIKING ONE OPEN FLOWER BRACKET, it only opens first linked cell,
URGENT BASIS,
THIS WILL SAVE MY TIME
Please find the attached file
--
Thanks Regards
Shivashankar.C.Katageri.
Hi -
This link should provide you to head start on how to write macro. This
could be customized based on your needs.
http://support.microsoft.com/kb/213360
Hope this helps,
Dev
--~--~-~--~~~---~--~~
Have a look at this link, the second to last message may help there is
a user form based quiz to download
questions can added to a shhet answears are submitted by user
HI,
Name - Harmeet
Tip - Calculate formula using F9
Detail :
Lets say you have a formula :
=IF(MONTH(B1)9,YEAR(B1)+1,YEAR(B1))
in order to calculate partial formula you need to select desired formula
like this:
=IF(MONTH(B1)9,YEAR(B1)+1,YEAR(B1))
Then press F9, it will convert the formula to
HI,
Name - Harmeet
Tip - Calculate formula using F9
Detail :
Lets say you have a formula :
=IF(MONTH(B1)9,YEAR(B1)+1,YEAR(B1))
in order to calculate partial formula you need to select desired formula
like this:
=IF(MONTH(B1)9,YEAR(B1)+1,YEAR(B1))
Then press F9, it will convert the formula to
I don't think so this is possible in excel(if we don't use a VBA
code)... you can go to one cell at a time.
You can use the formula auditing toolbar to have more options.
Nishant
On Jun 23, 7:43 pm, shivashankar katageri shankarkatag...@gmail.com
wrote:
DEAR ALL,
CAN ANY ONE HELP ME OF
I've seen it written that ranges can't be used as constants.
I've got 2 different ranges that I refer to on every worksheet and in
many subs and functions. I can't figure out how to declare the ranges
and have them available in all mod, sheets, subs, etc.
Here what I have in private subs:
Dim
Hi everyone,I need to get transfered coloums from one excel file
to amazon's file and also compare the inventory of the original file
to the amazon file I need help since I dont know excel too good. I
will also need it to work on a macro please let me know who is
interested to help me and of
Hi members,
Hope you all are doing well.
Please help me with a solution which, I am sure, will benefit others too.
Problem:It is very difficult to remember tones of figures
Solution: It is easier to remember nearest lower/higher figures
Formula/function required: If last
Hems
I have aquestion on how to use your form.
I am just learing Excel. I made your form come up once from your sheet but I
can not make it come up again.
Thank you.
Don
From: Harmeet Singh harmeet.hew...@gmail.com
To: Hems coolh...@gmail.com;
Hi Pat:
May be you could look at http://ideas.repec.org/c/wpa/wuwppr/0302001.html
and Then possibly extend based on your requirements
Thank you,
Dev
On Jun 20, 5:09 am, Pat Sheehan sheehanp...@gmail.com wrote:
Hi,I am looking to design a questionnaire via Excel with Yes/No options
against
Try this if it works
1. Add two columns of Party name and bill No with
formula =CONCATENATE(B7,C7) in both the sheets.
Party Name Bill no use formula
XYZ LTD 25 =CONCATENATE(B7,C7)
2.then try the VLOOKUP
if there is error in this vlookup after joining
21 matches
Mail list logo
