Hi there,
I'm using a template worksheet every week to estimate our production.
This template contains links to the last 3 weeks to receive
information to compare with.
When a week is finished and the information doesn't change anymore, I
would like to clear all the formula's in the current sheet
hello friends
i just figured out the way the solution of my problem.
Thanks for all the concerns
Regards,
Vivek Agrawal
Contact No. +91--154-077
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Sat, Jul 4, 2009 at 8:54 PM, vivek agrawal wrote:
> Hi all
> I a
Sub FollowHyperlinks()
Dim R As Integer
'For R = 1 To ActiveSheet.UsedRange.Rows.Count
For R = 1 To 10
ActiveWorkbook.FollowHyperlink Address:=ActiveCell
ActiveCell.Offset(1, 0).Select
Next R
End Sub
Regards,
Vivek Agrawal
Contact No. +91--154-077
Skype ID - vivek.agrawal83
GoogleMoonlight.
Well. going through other mails in the group... i found that somebody
have already posted a similar query... as an answer,
http://funwithexcel.blogspot.com/2009/05/how-to-open-url-list-from-excel-using.html
this link is given. but the code given in this doesnt seem to work as i
want. it opens
Hi all
I am new to this group.. was searching for excel macros and accidently came
across this great work ground. m highly impressed to see a place on net with
such enthusiasm. well.. i would also like to post my query.
I often have a list of http:// links in a column say from "B2" to "B100".
now
HI Dilip,
I am not finding Calendar Control in object menu. How did you inserted that,
kindly explain.
Thanks & Regards,
CA Narendra Ashara | M.Com., A.C.A. |
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Dilip Pandey
Sent: 04
Hi, Shrinivas.
Try :
Sub SimpleMail()
Dim olApp, m
Set olApp = CreateObject("Outlook.application")
Set m = olApp.CreateItem(olMailItem)
With m
.Subject = "Subject"
.Body = "Dear All," & Chr(10) & Chr(10) & _
"Find attached report as of 04-Jul-2009." &
Did you have a look at my workbook. The command "Date ?" is added to the
cell right click menu when the file is opened. It is removed when the file
closes.
Daniel
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] De la part de Lynn
> En
Dear Friends,
I requeired i coding to create a draft with attachement and also the draft
format should be in plain text.
Find attached draft for your reference.
Thanks & Regards,
Shrinivas
--~--~-~--~~~---~--~~
---
Hi Guys,
Am new to the forum and learning basics of Excel Vba. I now need to
find a list of values from sheet2 and delete it from sheet1. Tried
using the Find command in the following way
Cells.Find(What:=Sheet2.Cells(R2, C2), After:=ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlPart, Sear
this is not what I wanted. I do not want the calendar to be shown on
the excel sheet.
It should only pop-up when I click on the cell which I need to enter a
date.
Pls review this. thanks
On Jul 4, 2:52 am, Dilip Pandey wrote:
> Hi Lynn,
>
> Calender control has been explained in the attached wor
Hi Bala,
Thanks for the response, but i am new to macro.
just let me know where to put his code in the excel.
it would be great if you could send the updated file.
Thanks again,
Regards,
Kunal Rout.
On Jul 3, 2:42 pm, bala wrote:
> hi,
>
> try this code --> this example print excel file nam
Hi All,
Thanks a lot for the help
Ashutosh
-- Forwarded message --
From: Petr Hořejš
Date: 2009/7/2
Subject: $$Excel-Macros$$ Re: Help on copying formula.
To: MS EXCEL AND VBA MACROS
Hello,
You can use formula =transpose()
Good to see help, because you use other step
Levi,
The attached file has a few formulas that may be of some use
to you.
If this does'nt help you to get there, maybe someone can
help with some
alternatives or some VBA macros.
Regards,
Jayell
--~--~-~--~~~---~--~~
-
14 matches
Mail list logo