Hi,
You can try this code. The code has been taken from Open XL where
through a utility a cell or range of cells are exported as image (GIF/
PNG).
//Here is the subroutine:
Sub SaveRangeAsGif()
Dim MyChart As Chart
Dim objPict As Object
Dim RgCopy As Range
On Error Resume Next
Set RgCopy = Appli
Hi Jitendra,
There is no VBA way to delete all of them at once but manually you can
delete them very fast and efficiently.
1. Open the Name Manager (Formulas --> Name Manager(2007) or Insert--
>Name-->Define(2003))
2. Now select the first name.
3. Now Press, Ctrl + Shift + End to select all the d
Hi Sasikanth,
This is very wonderful. There are so many websites available
to give you a start. Buy some good Microsoft Press books:
http://www.excelitems.com/2009/03/free-e-book-on-vba-and-vsto-macros-and.html
Also subscribe us on Facebook and twitter for regular tips and
updates:
Facebook - ht
Hi Aswin,
This is very wonderful. There are so many websites available
to give you a start. Buy some good Microsoft Press books:
http://www.excelitems.com/2009/03/free-e-book-on-vba-and-vsto-macros-and.html
Try and if have some issue, discuss here or on Microsoft Forums.
We will be pleased to sol
Hi Kush,
The method explained below will stop annoying you because the
Internet Explorer 4.0, 5.0, 6, 7, and 8 time-out is based on the
number
of script statements executed, the time-out dialog box will not
display
during ActiveX control or database-access delays. Endless loops in
script will stil
Hi Val
There are several workarounds to solve your problem.
1. You can use formulas in O, P, AW and BL
linked directly to column D.
2. or create a macro to copy values from col.D
to O, P, AW and BL as required. Below is a
code, do reply if this was you looking for:
Sub Copy_Data()
Dim myCell
Yup Omar, you're right.
In your case it will be
SUB PAGE_SETUP()
On Error GoTo RESCUE
'*PAGE SET UP LINES*
'*
'*
'*HEADER & FOOTER
'REST CODE OR EXIT SUB
RESCUE:
' Your code if error
'RESUME NEXT (if
Hi,
I have attached a spreadsheet which contains list of document numbers and
their respective names. What I want is I need a word macro that will do the
following.
Note:
The file name will always starts with the Doc Number (5 digits). Ex: 12345
(Refer "Sample_Findlaw.xls" for list of Doc Number
Hi,
Write following formula beside date column, i.e. In cell C4:
=text(B4,"mmm")
Now copy this formula in all rows of coloumn C, You will get Month name like
Aug in cell C4.
Now you can use sum if.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: janet dickson
Sender:
hi,
Check this website hope you will find the resolution
http://www.homeandlearn.co.uk/excel2007/excel2007s6p4.html
Thanks,
Raj
On Tue, Nov 9, 2010 at 11:19 PM, janet dickson wrote:
> Hello Excel Gurus,
>
>
> I encountered a challenge on using SUMIF FUNCTION. Help me on summing total
Hello Excel Gurus,
I encountered a challenge on using SUMIF FUNCTION. Help me on summing total
amount in different months into different cells. See attached fine for
details.
--
--
Some important links for excel use
THANKS ashish
Before page setup lines we can use on error goto 1
Line
Line
...
1 end sub
Is that true?
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Ashish Jain
Sent: Tuesday, November 09, 2010 3:36 PM
To: MS EXCEL AND VBA MA
2010/11/9 neil johnson
>
>
>
>
>
> Hi,
>
> I make textbox in user form. The label of this texbox email . When i enter
> the email address with out using or forget @ and Dot(.). It should give me
> msg . please use valid email Id .
>
>
> Wht will be code of this . Please find the attache sheet.
>
There's lots of ways to accomplish this.
Some will depend on the version of Excel that you're using.
I have Excel 2007.
My first suggestion is:
Create a "template" sheet with the desired column widths and hide it.
Then, your macro can unhide the template,
select row 1
Copy to the clipboard
Loop t
First attempt at this, so hopefully this is how it works
I have a spreadsheet with about 25 tabs and about 200 columns with
lots of different widths. As its updated by many the widths get moved
about. Before it is released, I run a macro to go through each column
in each tab and restore it to it
Hi,
The following code will split the content in column "K" by using "|" as a
border key, but would like place another condition to move the cells in
different columns based on the character found in the cell.
Sub Split_content()
Dim objRange1 As Range
'Set up the ranges
Set ob
Hi Ayush,
Thanks a ton.. for the effort..
Something seems to be wrong at my end as the link you have given is not
opening..
Is there any way you can send the file to me plz..
Cheers,
Andy
On Mon, Nov 8, 2010 at 7:35 PM, Ayush wrote:
> Dear Group Members,
>
> Good news for all of you !!
>
> Now
Conditional Formatting
You can use something called Conditional Formatting in your spreadsheets.
Conditional Formatting allows you to change the appearance of a cell,
depending on certain conditions. What we'll do is to colour the Overall
Averages on our Student Exam spreadsheet, depending on th
Great info... Thanks for sharing keep it up..
On Tue, Nov 9, 2010 at 7:01 PM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:
> Conditional Formatting
>
>
>
> You can use something called Conditional Formatting in your spreadsheets.
> Conditional Formatting allows you to
Hi Mike,
Can you notice and send the back the change in Memory Usage by Excel
application before and after running the macro? You can locate it in
Task manager. You can try clearing clipboard(Application.CutCopyMode =
False) to experiment harmlessly.
Tha
Hi,
I have attached a spreadsheet which contains list of document numbers and
their respective names. What I want is I need a word macro that will do the
following.
Note:
The file name will always starts with the Doc Number (5 digits). Ex: 12345
(Refer "Sample_Findlaw.xls" for list of Doc Number
Hi Matt,
That's Great. We're our best teachers. Kudos :)
Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
__
Thanks Viju for sharing these tips. Great. Keep it up :)
Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
__
Wish you all fantastic work, appraisals and growth on the occasion of
Deepawali. May this auspicious occasion brings good health and lots of
wealth in your lives.
HaPpY CoDiNg !! HaPpY DiWaLi !! HaPpY ExCeL !!
Thanks & Regards
Ashish Jain
McKinsey India Kn
Hi Vaibhav,
You can use DYNAMIC NAMED RANGES or END Function.
1. Dynamic Named Range
=OFFSET(Sheet1!A1,0,0,COUNTA(Sheet1!$A:$A),1
Please refer Microsoft Help for Offset function to better understand
the arguments.
2. VBA END Function
You can determine last row instead of hard coding in your logic
Hi Omar,
There are 2 ways:
1. You can get the printer name using
Application.ActivePrinter
So, if there is no printer installed, skip through the code.
2. Error Handling to check printer installed or not
On Error GoTo RESCUE
Activesheet.printpreview
'your
Dear Sudarshan,
Please find attached sheet with solution...
With Regards,
Noorain Ansari
On Tue, Nov 9, 2010 at 2:06 AM, sudarshan rampe wrote:
> hi friends
> plz find the attached sheet in which i want a formula in which if i enter
> the month it should give no. of days of a month in the next
Hi Sidhu,
Please find attached the solution.
Regards,
Andy
On Tue, Nov 9, 2010 at 3:36 PM, sudarshan rampe wrote:
> hi friends
> plz find the attached sheet in which i want a formula in which if i enter
> the month it should give no. of days of a month in the next column. please
> help me out
Hi Ted,
Instead of "Excel.WorksheetFunction.Len" just use "Len".
So your code would look like:
iLen = Len(ary(iLoc))
Len function is available as VBA function too, so you
don't need to use excel function. This is same as you
are doing for conditional statement, IF.
Note: The moment you press . (
First of all...
You would think that Application.WorksheetFunction
would apply to ALL worksheet functions.
But in reality, it does not.
ONLY those WorksheetFunctions that were written in a manner accessible to VBA
are available.
It's something about the environment where they were developed.
Tha
Dear Sudarshan
Please see the attached file with the solution.
On Tue, Nov 9, 2010 at 1:06 PM, sudarshan rampe wrote:
> hi friends
> plz find the attached sheet in which i want a formula in which if i enter
> the month it should give no. of days of a month in the next column. please
> help me
hi friends
plz find the attached sheet in which i want a formula in which if i enter
the month it should give no. of days of a month in the next column. please
help me out
--
Sidhu
--
--
Some important links for exce
Hi Sumit,
Kindly mail me the PDF u've downloaded.
(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`·.¸.·´9910227325
On 9 November 2010 15:22, sumit kumar wrote:
> Hey
>
> There is no password, I opened it without password.
>
>
> Regards
> Sumit
>
>
>
> On Tue, Nov 9, 20
Hey
There is no password, I opened it without password.
Regards
Sumit
On Tue, Nov 9, 2010 at 3:03 PM, Upendra Singh Sengar <
upendrasinghsen...@gmail.com> wrote:
> Hi Ayush,
>
> What is the password to opent the file.
> (¨`·.·´¨) Keep
> `·.¸(¨`·.·´¨) Smiling !!
> (¨`·.·´¨)¸.·´ Upendra Singh
Hi Ayush,
What is the password to opent the file.
(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`·.¸.·´9910227325
On 8 November 2010 19:35, Ayush wrote:
> Dear Group Members,
>
> Good news for all of you !!
>
> Now you can download VBA macros ebook worth $45 for free.
>
>
35 matches
Mail list logo