below code will help you in extracting the text on images see if it helps
you
Rectangle 1 , 5-Point Star 2 name of images or boxes
a = ActiveSheet.Shapes("Rectangle 1").TextFrame.Characters.Text
b = ActiveSheet.Shapes("5-Point Star 2").TextFrame.Characters.Text
On Thu, Jun 9, 2011 at 9:59 AM, D
Hi group,
I have 3 buttons on the worksheet which all fire the same macro. Each
button has different text, and the macro examins this text, and uses
it to run slightly differently depending on which button was used to
fire it. To obtain the text on the button, I use:
A = ActiveSheet.Buttons(Applica
Melina
see if it helps
try this link once you copied the sheet to new workbook the delte the code
of the worksheets. or instead of copying the sheet, copy the data in the
sheet and add a new sheet to new workbook and paste the data in it
http://www.ozgrid.com/VBA/delete-sheet-code.htm
On Thu,
I copy specific sheets from one book into a new book but I don't want
any VBA code in the new book. One sheet, however, has code in the
sheet module. How can I copy it without the code or remove the code in
the destination book?
For the copy, I'm simply using...
Sheets(Array(sShtName1, sShtName
Vasant,
Can I run the following as is or do I have to make changes to the path etc?
I tried running as is,and I'm getting an error Previous Month File does not
exist. I saved both files on desktop.
Sub UpdateFormula2()
Dim Flnm As String, Mn As String, Yr As Integer, PrevMn As String
Dim FlPath A
Dilip,
Ok, I will approve the external link if it is opening form for that specific
job only.
I hope that is fine.
Dear Group,
Start posting jobs :)
Regards
Ayush Jain
Group Manager
--
--
Some important link
issue = INDEX(E:E,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0)
reading =INDEX(F:F,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0)
On Wed, Jun 8, 2011 at 7:03 PM, Subhash Yadav wrote:
> Dear friends,
>
> I am having one sheet containing data for fuel issue.
>
> I want, if i put any asset c
check the attachment see if it helps
On Wed, Jun 8, 2011 at 8:37 PM, Sarah Seager wrote:
> Hi,
>
> I regularly have to look at raw data that shows me the age of people.
> However for most of my analysis I have to convert these ages into 5
> year age bands (0-4y, 5-9y,.75-59y, 80-84y and 85+)
Hi,
I regularly have to look at raw data that shows me the age of people.
However for most of my analysis I have to convert these ages into 5
year age bands (0-4y, 5-9y,.75-59y, 80-84y and 85+)
The column that my ages is in is never the same, so I'd like my macro
to run on whatever cells I se
can you share you sample workbook of 2 or 3 sheets
On Wed, Jun 8, 2011 at 6:48 PM, Kat wrote:
> I'm sorry, I'm still not having any luck with this. I'm getting
> runtime error 91, object variable or With block not set.
>
> Does this mean that when you select the sheets you deselect your
> char
HI
Please use this Code
Sub HighLight()
Dim rng As Range
ActiveCell.CurrentRegion.Select
Set rng = Selection
ActiveCell.Resize(1, rng.Columns.Count).Interior.Color = 15773695
rng.Cells(rng.Rows.Count, 1).Resize(1, rng.Columns.Count).Interior.Color =
15773696
End Sub
Rajan
Fro
Dear friends,
I am having one sheet containing data for fuel issue.
I want, if i put any asset code previous issue and previous reading should
come from the latest present issue and present reading of same asset.
In the attached sheet yellow cell date should come in yellow cell and
magenta cell
I'm sorry, I'm still not having any luck with this. I'm getting
runtime error 91, object variable or With block not set.
Does this mean that when you select the sheets you deselect your
chart? How do I best write the code within the loop so that I do not
get this error?
On Jun 6, 3:22 pm, ashish
Hi,
Please find attached file here I want to highlight first and last row of the
region, Please let me know how to do this in VBA.
Thanks,
Chandra Shekar B
--
--
Some important links for excel users:
1. Follow us o
You may filter out the null values. Each time, you'll have to refresh the
filter either manually or with a macro.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Joni Childers
Envoyé : mardi 7 juin 2011 23:46
À : MS EXCEL A
Let's say start dates are in B and finish dates are in C. In K6, the formula
will be :
=IF(C6="",NA(),C6-B6)
Copy downward
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Joni Childers
Envoyé : mardi 7 juin 2011 23:46
À : M
Very Good idea, thanks Ayush and Ashish for this initiative.
On Tue, Jun 7, 2011 at 11:19 PM, Dilip Pandey wrote:
> Good initiative Ayush and many thanks to Ashish.
>
> I am having one doubt. Some job application needs to be filled up
> online and hence external link is mandatory. Pl
17 matches
Mail list logo
