I have no intent of doing a job posting. Asking for others. Where should job
postings be done. I am in British Colulmbia Canada. What should I do if I want
to change to change my email receiving address for this group?
Thank you.David
Date: Sat, 16 Jun 2012 08:14:00 -0700
From: jainayus...@g
My post should work, but I made a "boo boo". The SizeColumns macro should
not have Set Workbook=Nothing at the end. Workbook was a parameter to the
procedure, and setting it to Nothing will effect whatever other procedure
called SizeColumns.
Here is the corrected version of SizeColumns:
Su
Prashant:
My guess is that your request is for a macro that will only Auto-Increase
column widths -- never decrease them, which would unneccesarily change the
look of the spreadsheet.
Excel does not have a method of specifically identifying cells (or columns)
where text has "overflowed", but I
Hi Ayush,
Thank you but am helping someone who is really need in job... Its a
gr8 opportunity where u have made this community a success and helping
others in their day to day work.
I would like to make 1 suggestion to this .. Please allow us to post job
related only for field related to MIS
Hi Yogananda,
Please note that Job posting is *NOT* allowed in this forum. Hence, do not
post any jobs going forward.
Thanks.
On Saturday, 16 June 2012 16:41:50 UTC+5:30, (%Allmydreams%) wrote:
>
> Hi,
>
> We have a opening for MIS - Executive in Bangalore location. Do call my
> below n
Hi Yogananda,
Please note that Job posting is allowed in this forum. Please do not post
any jobs going forward.
Thanks.
On Saturday, 16 June 2012 16:41:50 UTC+5:30, (%Allmydreams%) wrote:
> Hi,
>
> We have a opening for MIS - Executive in Bangalore location. Do call my
> below number on
Jacob John is banned.
-Ayush Jain
On Thursday, 14 June 2012 22:53:13 UTC+5:30, Jacob john wrote:
> Hello Consultant,
> Please let me know if you are interested in this requirement. If yes,
> kindly send us your
>
> resume along with contact information.
> If you are not looking for new proje
Sam, yours and mine both test OK
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Saturday, June 16, 2012 9:11 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Find Narrow Cells & Appying Auto fit to only that
cell
Should
Should be *EntireColumns* as I had posted
Regards,
Sam Mathai Chacko
On Sat, Jun 16, 2012 at 7:29 PM, dguillett1 wrote:
> or
>
> ActiveSheet.UsedRange.Columns.AutoFit
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Sam Mathai Chacko
> *Sent:* Sa
or
ActiveSheet.UsedRange.Columns.AutoFit
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Saturday, June 16, 2012 6:09 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Find Narrow Cells & Appying Auto fit to only that
cell
findNEXT should be faster. See my code.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: JLO
Sent: Saturday, June 16, 2012 8:03 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ change content of cell across multiple worksheets
David, you're a Star
I’m not sure what you are trying to do but tested finding 1000 in column O and
putting 1200 in the cell 4 columns to the right
Assuming the code provided does work as desired, try this to use findnext in
each sheet/
Sub tryit()
Dim ws As Worksheet
Dim mySearch As String
Dim myReplaceValue
Dim c
David, you're a Star! Thank you so much - didn't expect the counter
addition - very thoughtful of you. It works brilliantly!
Orange on its way...! :-)
On Saturday, June 16, 2012 12:05:30 PM UTC+1, David Grugeon wrote:
> Final version including force uppercase input and counter so you know what
Provide a file and a complete explanation.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: David Grugeon
Sent: Saturday, June 16, 2012 2:32 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: change content of cell across multiple
worksheets
Hi
Hi,
We have a opening for MIS - Executive in Bangalore location. Do call my
below number on next coming monday. Its Urgent requirement
Regards
Yogananda Muthaiah
Ph : 973 123 7267
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
You cannot apply autofit only to one cell. It has to apply to a whole
column. One cell cannot be a different width than the column. The only
way you could achieve that appearance would be to merge cells.
Regards
David Grugeon
On 16 June 2012 18:10, Prashant Pawle wrote:
> Dear Team,
>
> Plea
ActiveSheet.usedrange.entirecolumn.autofit
Sam Mathai Chacko
On Sat, Jun 16, 2012 at 4:28 PM, Rajan_Verma wrote:
> Select the Column and press
>
> ALT + O C A
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups
Final version including force uppercase input and counter so you know what
it has done
Completed with Ucase and Counter.
Sub UpdateCode()
Dim mySearch As String
Dim myReplaceValue As String
Dim ws As Worksheet
Dim c As Range
Dim Counter As Long
mySearch = UCase(InputBox("Enter the Box Number re
Select the Column and press
ALT + O C A
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prashant Pawle
Sent: 16 June 2012 1:40
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Find Narrow
Dear Team,
Please help of some macro to find Narrow Cells & Appying Auto fit to only
that cell , sample sheet attached
Regards,
Prashant
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need H
Hi Jeanette
Ah! I expect we have some sort of misunderstanding.
Are the sheets concerned actually called "A" to "Z". If not we may have to
change the macro to run on selected sheets.
Also is the information you are looking for actually in column O?
How is the information formatted? Is it as
21 matches
Mail list logo