Perhaps you have more than one sheet selected.
Regards
David Grugeon
On 28 May 2013 14:37, Prabhu Pinky prabhupin...@gmail.com wrote:
hi experts
I have one excel, from that excel I am unable to copy and paste the data
to new excel..even a single cell..am getting this command is cannot
Bulloo Shire Council in Thargomindah Queensland Australia.
Regards
David Grugeon
On 27 May 2013 16:13, VBA VABZ v...@vabs.in wrote:
hey
for which co you work.
thx
On Mon, May 27, 2013 at 7:20 AM, Bv Dileep bvdil...@gmail.com wrote:
Hello,
** **
Please find attached the sheet
might be possible if you have it rght aligned in a cell and put
the horizontal text, a space, and the first letter of the vertical text, an
Alt-return, the next vertical letter, and so on like this
*fred F*
*R*
*E*
*D*
Regards
David Grugeon
On 27 May 2013 16:59, Prathap prathap@gmail.com
the entire code for you that is a consulting job. I currently
charge my clients AUD 140 per hour for such services. If you do it
yourself you will be better placed to cope with other issues in the future.
Regards
David Grugeon
On 27 May 2013 11:50, Bv Dileep bvdil...@gmail.com wrote:
Hello
to
excel-macros@googlegroups.comjavascript:_e({}, 'cvml',
'excel-macros@googlegroups.com');
.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Regards
David Grugeon
--
Are you =EXP(E:RT) or =NOT(EXP
Can't guess without seeing the file. Can you attach it?
Regards
David Grugeon
On 23 May 2013 16:49, Prabhu Pinky prabhupin...@gmail.com wrote:
Hi experts,
I have one excel file. Size is below 1mb. Even though it is very slow
working in that file. If I do copy paste any single cell
worksheets, or by keeping calculation turned off and pressing F9 when you
want it to calculate.
Regards
David Grugeon
On 23 May 2013 21:26, Prabhu Pinky prabhupin...@gmail.com wrote:
thanks vijay, lemme try this too.
but my doubt is if already Use all the processors on this computer
option
Also do you have macros which are run when changes are made to the sheets.
It may be possible to reorganise them so they run faster or are not
triggered so readily.
Regards
David Grugeon
On 23 May 2013 21:47, David Grugeon da...@grugeon.com.au wrote:
Try setting the calculation to Manual
@googlegroups.comjavascript:_e({}, 'cvml',
'excel-macros@googlegroups.com');
.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Regards
David Grugeon
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
Can they open the files through the network manually while the files are on
you computer
On Wednesday, 22 May 2013, Chaya wrote:
Dear experts,
I have more then three excel (Say A, B, C) file in under folder
(D:\Master File). Now I have a single workbook know as “Master file”. In
the
Excel can do it but unfortunately the restriction not to use VBA prevents
it. Perhaps you should talk to your IT department and ask them how to
solve it.
Regards
David Grugeon
On 19 May 2013 07:02, santosh subudhi santoshkumar.subu...@gmail.comwrote:
Hi Group,
Attached is the sample sheet
Did you mean to attach the file?
Regards
David Grugeon
On 17 May 2013 14:32, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Respected Prabhu,
Hope this file will be of little help to u.
Regards,
VIJAYKUMAR
On Tue, May 14, 2013 at 9:08 PM, Prabhu Pinky prabhupin...@gmail.comwrote:
Hi all
and what it is doing
wrong. If there are any error messages write them down exactly and tell
us, if it is possible to find out, what line the error occurred on.
Above all, just keep writing and testing code and you will soon be one of
the ones giving the answers on the list.
Regards
David Grugeon
MyConvertFormulas()
Dim oRange As Range
Dim c as Range
Set oRange = Selection
for each c in oRange
c.Formula = Application.ConvertFormula(Formula:=c.Formula, _
fromreferencestyle:=Application.ReferenceStyle,
toabsolute:=xlAbsolute)
End Sub
Regards
David Grugeon
On 17 May 2013 01:22, Chris
End Sub
Regards
David Grugeon
On 17 May 2013 07:44, David Grugeon da...@grugeon.com.au wrote:
The main issue is where the references point. If they are pointing within
the block you are copying, there is no issue as they will continue to point
to the appropriate cells within the block
=,,the formula)
I hope this is clear.
Regards
David Grugeon
On 17 May 2013 10:50, Christopher Kevin christopher@gmail.com wrote:
David, thank you it worked perfectly, however, when I use the fill handle
to drag and fill down I ended up with 0, #NA and 0/01/1900 on the filled
row. How do I
It is possible using VBA. Please supply a sample workbook so we can
understand exactly how your data is organised and how you want to look it
up.
Regards
David Grugeon
On 15 May 2013 13:51, Prabhu Pinky prabhupin...@gmail.com wrote:
Nope. it is not possible..
On 15 May 2013 01:14
The formula refers to 34 in B5 but B5 is 36, not 34
Regards
David Grugeon
On 15 May 2013 16:41, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Respected Experts,
My exact requirement is that if 12(or any constant number specific to
login) is typed in Cell B4 of the attachment it should display
Easier with formulas - see attached. I had to change the ID for ABC from
FR002 to FR001 to match the details. Also I did not get the swapped items
in the last 2 rows shown in your combined.
Regards
David Grugeon
On 16 May 2013 12:38, Christopher Kevin christopher@gmail.com wrote:
Dear
Sorry - Attachment here
Regards
David Grugeon
On 16 May 2013 13:12, David Grugeon da...@grugeon.com.au wrote:
Easier with formulas - see attached. I had to change the ID for ABC from
FR002 to FR001 to match the details. Also I did not get the swapped items
in the last 2 rows shown
You cannot filter horizontally. You could have a macro to hide all columns
from column d onwards which were not Week1, if that is what you want.
Regards
David Grugeon
On 10 May 2013 16:28, Amit Desai (MERU) amit.de...@merucabs.com wrote:
Dear Friends,
** **
Please help
, I think.
Or you could upload the file to Google Apps or Office 365 and then open
that in a browser.
Regards
David Grugeon
On 9 May 2013 16:31, Mathan mathan4s...@gmail.com wrote:
Hi David/Anil,
We are trying to upload the excel file through excel vba.
The files are from common shared
David Grugeon
On 10 May 2013 06:42, Mathan mathan4s...@gmail.com wrote:
Sorry, please refer to this screenshot. Thanks
On Fri, May 10, 2013 at 2:11 AM, Mathan mathan4s...@gmail.com wrote:
Hi David,
Please refer to the attached screenshot. I believe you would get my point
after seeing
the
terms CCG, Channel, and Impression mean, it may be feasible for me or
another member (ideally a statistician) to help you further.
Regards
David Grugeon
On 10 May 2013 13:47, Sri Jai jaisri1...@gmail.com wrote:
Dear Experts,
Need your help on the below
Attached is an example that uses
From the data available there is no way to determine how many users have 3
or more channels.
Regards
David Grugeon
On 10 May 2013 15:34, Sri Jai jaisri1...@gmail.com wrote:
Thanks david for the response
I think i confused you uncessarilly..(Apologies)As attached in the
word
Priti, You are absolutely right. It is up to the person who raised the
query to test sugestested solutions and respond. If it is not working to
say in what respect it is not working, If it is working to acknowledge
that.
Regards
David Grugeon
On 8 May 2013 22:16, priti verma pritiverma1
is located.
We also need to know why VBA code is required, rather than simply a
hyperlink.
Regards
David Grugeon
On 9 May 2013 06:56, Mathan mathan4s...@gmail.com wrote:
Hi Experts,
I'm trying to upload a file from shared folder (directory) to the internet
explorer.
Need a VBA code to do
You are more likely to get a response if you use a meaninful heading and
include the details of your problem in the body of the post.
Regards
David Grugeon
On 3 May 2013 03:33, SAJID MEMON sajidwi...@hotmail.com wrote:
I have attached a file, please give me vba code of my problem which i
Shift:=xlUp
Regards
David Grugeon
On 30 April 2013 13:56, excel learner knowledgeforex...@gmail.com wrote:
this particular line it is Just skipping Rows(102: k).Select
and deletion line also not performed.
On Mon, Apr 29, 2013 at 4:19 AM, David Grugeon da...@grugeon.com.auwrote
You have highlighted 5 lines
Try stepping through the code and finding out which line does not work as
required.
Regards
David Grugeon
On 28 April 2013 16:25, knowledgeforex...@gmail.com wrote:
Hi Experts,
i have come across an issue where in auto filter code is skipping over
without
it do? Are the rows still selected? If not, where is the active
cell after this line is run?
Regards
David Grugeon
On 28 April 2013 16:36, excel learner knowledgeforex...@gmail.com wrote:
hi David,
I tried step by step execution but still it is executing fine without any
error but deletion
.
--
Regards
David Grugeon
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please
this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Regards
David Grugeon
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page
I cannot understand your question. you will have to be much more explicit.
If you cannot explain in English, perhaps you know someone who can help
you.
Please put the explanation in the body of the email, not in a spreadsheet.
Regards
David Grugeon
On 19 March 2013 21:40, amar takale
Sorry. Dont use that use this one
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
Application.EnableEvents = False
Worksheets(5).PrintOut
Application.EnableEvents = True
End Sub
Regards
David Grugeon
On 19 March 2013 22:08, David Grugeon da...@grugeon.com.au wrote:
Put
@googlegroups.com');
.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Regards
David Grugeon
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
It works perfectly on my spreadsheet.
I think you filled the dates using a formula. Change xlFormulas to
xlValues.
It would also be good to put Dim r as Range at the head of the macro.
Regards
David Grugeon
On 15 March 2013 23:47, Prashant Pednekar prashant...@gmail.com wrote:
Dear Dave
The problem is that you are replacing a string with another string when you
want to replace it with a formula
So Try
ActiveCell.formula =Replace(ActiveCell.Value,#,=,1,,vbTextCompare)
Regards
David Grugeon
On 16 March 2013 04:10, André D'Avila andredavila...@gmail.com wrote:
Hey Prince
In the This Workbook module put the following Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheet1.TextBox1.Text =
ThisWorkbook.Save
End Sub
Regards
David Grugeon
On 14 March 2013 19:37, Umesh Gupta umeshj...@live.com wrote:
--
From: umeshj
with trying to force you to use the cloud, they then
think that the cloud is an unsafe place so disable macros by default.
Regards
David Grugeon
On 15 March 2013 07:28, Wayne Field awf@gmail.com wrote:
I moved up to Excel 13 less than a month ago with functioning
spreadsheets. Last night
It is just a case of illiteracy. Sales recruiter evidently cannot read or
he/she would see that the rules include:
5) Jobs posting is not allowed.
Regards
David Grugeon
On 13 March 2013 14:20, अनिल नारायण गवली gawlianil8...@gmail.com wrote:
Dear SalesRecruiter,
What we do wit
plenty of time to spare and be willing
to donate that time.
Regards
David Grugeon.
Regards
David Grugeon
On 11 March 2013 16:33, karthikeyan sankaran karthikeyansankar...@gmail.com
wrote:
Hi,
Thanks for your reply.
I need Active cell RowColumn. Whenever open the workbook it will show
the quotes so two double
quotes. VBA will treat them as a single double quote when it interprets
the string.
I haven't tested this but I think it is about right.
Regards
David Grugeon
On 11 March 2013 04:26, Santosh V eclerxsant...@gmail.com wrote:
Private Sub CommandButton1_Click
, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Regards
David Grugeon
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
.
--
Regards
David Grugeon
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
, or is it just wrong?
Regards
David Grugeon
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
@googlegroups.com');
.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Regards
David Grugeon
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official
Why did you post this?
Rule 5) Jobs posting is not allowed.
You have done this before. Please do not do it ever again.
Regards
David Grugeon
On 5 March 2013 12:15, pankaj sangotra psangotr...@gmail.com wrote:
Job Description
* Should have good knowledge of Work force management
This thread makes me think you are typing in the names of your named
ranges. It is bettter to press F3 and double click the name to add it.
Makes sure there are no typos in the name.
Regards
David Grugeon
On 28 February 2013 18:03, Bé Trần Văn betnmtdongna...@gmail.com wrote:
Go to Insert
=SUMIF(A2:A7,F9,OFFSET(A2:A7,0,CODE(F8)-64))
Regards
David Grugeon
On 1 March 2013 11:50, Venkat CV venkat1@gmail.com wrote:
Hello Everyone,
I have enclosed sample file were i required formula assistance If I
select 2 Criteria's and needs to sum up based on ROWColumn criteria's
',
'excel-macros@googlegroups.com');
.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Regards
David Grugeon
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW
.
Regards
David Grugeon
On 27 February 2013 16:49, amar takale amartak...@gmail.com wrote:
Dear All,
Can anyone tell me how I can allocate an F-key to open a particular
worksheet.I will try but not successful. Pls see below link,same issue.
https://groups.google.com/forum/?fromgroups=#!topic
=sumif(C2:C50,6500,C2:C50)+countif(C2:C50,=6500)*6500
Regards
David Grugeon
On 23 February 2013 20:36, Ranjeet Negi ranjitsne...@gmail.com wrote:
Dear Sir,
I have a data in Range (C2:C50). There are values. I want to sum all
value upto or equal to 6500, wherein values greater than 6500
try this
If the value is in B3 use then formula
=(int(B3)+mod(B3,1)/.6)/24
then format as h:mm
Regards
David Grugeon
On 22 February 2013 20:36, The Viper viper@gmail.com wrote:
excel will not hold a value as 2.30 with full decimal(2). We
can derive the desired result by formula if you
by the
number.
0.1770833 or thereabouts.
When we apply a time format h:mm to this it displays as 4:15.
QED
Regards
David Grugeon
On 22 February 2013 21:30, David Grugeon da...@grugeon.com.au wrote:
try this
If the value is in B3 use then formula
=(int(B3)+mod(B3,1)/.6)/24
then format as h:mm
Assuming the first value is in A2
In B2 put =left(A2,1)
In C2 put =mid(A2,2,4)
Drag these formulas down.
Regards
David Grugeon
On 23 February 2013 16:14, Harkesh Kumar harkesh.kuma...@gmail.com wrote:
Please solve this Problem
Please Seperate Special character and number
num
Ans
it to apply
to)
PasteSpecial/Formats
It should be easier but I could not get it to work to just apply
conditional formatting to the range.
Regards
David Grugeon
On 21 February 2013 01:50, solsbee joesolsbe...@gmail.com wrote:
I have a spreadsheet that the data is keyed in one cell
Hi Anton
How are you calling the sub?
Regards
David Grugeon
On 20 February 2013 04:40, Anton Jopko a...@kwic.com wrote:
Hi David,
I tried your suggestion but still no luck. I may have to get a VBA book
that is simpler than the one i have.
Thanks for looking at my macro though,
anton
tax =
value*1.392+value*1.392*0.06
=value *1.392*1.06
=value*1.47552
so the Custom duty, plus the Sales tax plus the income tax is
Value*0.47552
This is the formula you need in the single cell if the value is in A3
*=A3*0.47552*
Regards
David Grugeon
On 19 February 2013 17:48
the year and ended after the year he wants 365
or 366 in that year column.
Regards
David Grugeon
On 19 February 2013 22:42, Paul Schreiner schreiner_p...@att.net wrote:
I'm really very sorry, but your explanation continues to make no sense.
Basically, it's this:
You want the number of days
Hi Paul - OOPS! I didnt see you had finished it. Sorry.
Regards
David Grugeon
On 20 February 2013 07:08, David Grugeon da...@grugeon.com.au wrote:
Hi Paul
What i think the OP wants is
If a person started in the year he wants the end date of the year (31
December) minus Start date
Following message posted direct to Anton by mistake. It worked.
Regards
David Grugeon
-- Forwarded message --
From: David Grugeon da...@grugeon.com.au
Date: 17 February 2013 07:16
Subject: Re: $$Excel-Macros$$ how to get cumulative sum in a cell
To: anton a...@kwic.com
Have
Hi Anton
How are you calling this sub? You are probably calling it without
specifying Target.
You might need to start it like (untested)
Private Sub Accounting_type2()
Dim Target as range
Set Target = ActiveSheet.ActiveCell
Regards
David Grugeon
On 19 February 2013 00:58, Anton Jopko
was issued (and after it came back to me if relevant).
If you have an earlier version of Excel you can do the same things but
someone else may need to tell you where to find the tools.
Regards
David Grugeon
On 18 February 2013 13:48, Prabhakar S H prabakar.k...@gmail.com wrote:
Hi,
I have different
to avoid
this.
Regards
David Grugeon
On 18 February 2013 15:30, अनिल नारायण गवली gawlianil8...@gmail.com wrote:
Dea Orabakar,
Pl find attached herewith . Password is hide.
Regards,
Gawli Anil
On Mon, Feb 18, 2013 at 9:18 AM, Prabhakar S H prabakar.k...@gmail.comwrote:
Hi,
I have
I suggest restarting the computer. In win8 it is not obvious how to do
this. I type the Windows key and then type Shutdown. this brings up the
shutdown App. Then you click Commands in the menu and restart.
Regards
David Grugeon
On 16 February 2013 03:23, anton a...@kwic.com wrote:
Hi
Perhaps it is an employment test. Anyone who knew Excel would know there
is no Ylookup. Someone who was not familiar with excel might invent a
menaing for it!
Regards
David Grugeon
On 16 February 2013 18:57, Rajan_Verma rajanverma1...@gmail.com wrote:
*I have year only two dimension
Perhaps it is an employment test. Anyone who knew Excel would know there
is no Ylookup. Someone who was not familiar with excel might invent a
meaning for it!
Regards
David Grugeon
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
@googlegroups.com');
.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Regards
David Grugeon
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official
/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Regards
David Grugeon
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com
a change in server paths on your network could
be responsible.
Regards
David Grugeon
On 15 February 2013 02:52, sreekanth m sreekanthm.namb...@gmail.com wrote:
Dear Experts,
I have an Excel tool which takes data from ALM(HP) tool and prepare the
reports.
*Now very frequently the TOOL is getting
try semicolons instead of commas
Regards
David Grugeon
On 10 February 2013 20:08, Sreejith K.V itssre...@hotmail.com wrote:
Hi There,
I have tried adding the below number format code in the custom tool bar.
But i not getting the desired result. Can someone help me in fixing this
and let
It looks as though you right click on the number and then click spell
Number
Regards
David Grugeon
On 10 February 2013 21:10, Prajakt Pande prajakt.pa...@gmail.com wrote:
Dear David,
I install but i didn't understand following sentence.
Do not forget! The ''SpellNumber'' command
green
square, it inserts the text after the number.
Regards
David Grugeon
On 10 February 2013 21:51, Prajakt Pande prajakt.pa...@gmail.com wrote:
I tried this also but doesn't work.
Thanks Regards,
Prajakt Pande
+971551388482
**
On Sun, Feb 10, 2013 at 3:30 PM, David Grugeon da
Hi Joseph
It is certainly possible. I don't really have the time to do it right now.
I am very busy at work but someone else may be able to help.
On Sunday, 10 February 2013, joseph camill wrote:
can I get the same in vba
On Sun, Feb 10, 2013 at 5:18 AM, David Grugeon
da
file. as per
company policy.
Please help. if it is keyboard shortcut it will be very good.
Thanks Regards,
Prajakt Pande
+971551388482
**
On Sun, Feb 10, 2013 at 4:29 PM, David Grugeon da...@grugeon.com.auwrote:
I tried it and it works fine. After it is installed you have to close
word
Regards,
Prajakt Pande
+971551388482
**
On Mon, Feb 11, 2013 at 11:28 AM, David Grugeon
da...@grugeon.com.aujavascript:_e({}, 'cvml', 'da...@grugeon.com.au');
wrote:
There is some actual vba code
On the MS website at
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360
Te
you want.
Regards
David Grugeon
On 1 February 2013 14:26, joseph camill joseph.cam...@gmail.com wrote:
database.xlsxhttps://docs.google.com/file/d/0B3PqgZIh0KQSMnhNY3RLWVRDcW8/edit
Hi,
Attached is the excel, for which I need some help.
I want to paste data from one sheet to another
more though to exactly what you want aqnd get back to us
someone will be able to assist you.
Regards
David Grugeon
On 10 February 2013 15:01, black panther prajakt.pa...@gmail.com wrote:
Dear Team,
Please help in this.
On Thursday, February 7, 2013 2:07:08 PM UTC+4, black panther wrote
these items.
Regards
David Grugeon
On 7 February 2013 23:14, FreeRangeJ jsgilchr...@gmail.com wrote:
I'm building a template for processing supplier billing data with the
corresponding process documentation for someone else to use the template on
a monthly basis.
It's based on mobile phone
to this group, send email to
excel-macros@googlegroups.comjavascript:_e({}, 'cvml',
'excel-macros@googlegroups.com');
.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Regards
David Grugeon
No
Your request was to copy product codes from the excel cells to the word doc.
Regards
David Grugeon
On 5 February 2013 10:19, harneetsingh2...@gmail.com wrote:
**
Can we pull excel tables, charts and smart art diagram using mail merge!!
Looking for some advice
Thanks
Harneet
Sent
+unsubscr...@googlegroups.com javascript:;.
To post to this group, send email to
excel-macros@googlegroups.comjavascript:;
.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Regards
David Grugeon
it
somewhere, and then restore it, but I suspect that is not possible.
Regards
David Grugeon
On 2 February 2013 15:56, pawel lupinski lupins...@yahoo.com wrote:
Hi All,
I've macro like:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range(B23:HH400
solution.
1)
Regards
David Grugeon
On 3 February 2013 16:43, joseph.cam...@gmail.com wrote:
**
Does anyone in the group does not have solution to check its row heading
and column heading and paste the data.
Sent on my BlackBerry® from Vodafone
--
*From
to be a 1 for 1 match
with the input descriptions (although in a different order)?
4) are you going to want to do any arithmetic within the report or is it
just a case of reordering the input for each region?
Regards
David Grugeon
On 3 February 2013 17:01, David Grugeon da...@grugeon.com.au wrote:
Hi
.
Regards
David Grugeon
On 1 February 2013 04:27, santhosh qatester santhosh.qat...@gmail.comwrote:
Hi,
I have the value as below in one cell which should assign the
Today's date to particular value
WHERE( ImportDate= Today())
How to assign today's date to the variable above?
Thanks
There are Microsoft office specialist exams in each product in office. You
can just do the excel one. It is not an online exam but is conducted in
various centres. See the Microsoft website for details.
Regards
David Grugeon
On 1 February 2013 00:58, Manjunath Narayanappa
manjunath.narayana
Put
Learn . net
into Google and you will get about 74 million possibles
Regards
David Grugeon
On 30 January 2013 17:52, hanumant shinde arsfan2...@yahoo.co.in wrote:
Hi friends,
i dont know ANYTHING about .net. and now want to learn it does anybody
know how shud i start with it.
Any
(or things don't work).
It looked a bit like saying x=worksheet(Sheet1).value to me.
Anyhow it looks like a minor change has caused you some recoding. Good
luck!
Regards
David Grugeon
Regards
David Grugeon
On 29 January 2013 07:06, Paul Schreiner schreiner_p...@att.net wrote:
David
options, visit https://groups.google.com/groups/opt_out.
--
Regards
David Grugeon
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Regards
David Grugeon
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent
Check on that machine that the reference to Excel is ticked.
Check that Excel or office is installed on that machine.
Regards
David Grugeon
On 29 January 2013 05:19, hanumant shinde arsfan2...@yahoo.co.in wrote:
Hello Friends,
set xyz = new Excel.Application
I am getting error no. 48
logon or else
gicve the scheduler logon access to all the resources needed.
You probably have set up a user for the Scheduler. Try logging on as that
user and then open the file and test the macro.
Regards
David Grugeon
On 29 January 2013 09:49, Richard richard.m...@gmail.com wrote:
I have
this group at http://groups.google.com/group/excel-macros?hl=en.
--
Regards
David Grugeon
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
David Grugeon
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may
@googlegroups.com');
.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com javascript:_e({}, 'cvml',
'excel-macros%2bunsubscr...@googlegroups.com');.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
Regards
David Grugeon
--
Join
://groups.google.com/group/excel-macros?hl=en.
--
Regards
David Grugeon
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
Seems to be 2120
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or
Sorry - that is the hex unicode for the character. I don't think CHAR()
does unicode.
Regards
David Grugeon
On 18 December 2012 22:48, David Grugeon da...@grugeon.com.au wrote:
Seems to be 2120
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
1 - 100 of 227 matches
Mail list logo