Hi,
If you want the same functionality without macros, you'll have to remove all
the buttons and replace them with cells containing hyperlinks. Let us know if
you need assistance with this.
Regards - Dave
Date: Fri, 11 Feb 2011 20:18:55 +0500
Subject: $$Excel-Macros$$ Button programming
From
Hi Usha,
I dont have that file rt now but we can do both the things.
2nd u urself can do u just need o make thse boxes transperent by folloeing
below
steps.
wen you want to take the print out you can right click on the box click
on"format shape" increase the transparency to 100%1st for "Fill
Hi,
I have an excel sheet and I want to filter for BLANKS in multiple columns
and provide comment of the other column. Can some one help me writing a
macro/add-on? expand »
Here each time the columns will not be the same, so it would be good if the
macro asks for the range and perform the act
Hi All,
The macro below send the current workbook to exchange server : In
Excel select File > Send To > Exchange Folder..
Sub send()
Select Case Application.MailSystem
Case xlMAPI
MsgBox "Mail system is Microsoft Mail"
Case xlPowerTalk
MsgBox "Mail system is PowerTalk"
Case xlNoMailSystem
MsgBox "
I think your description is a little off.
evidently, you're testing column C=1
your IF statement checks to see if the following row matches criteria.
I can do it very quickly with a macro.
This macro processed 1300 lines in about 3 seconds.
Sub Insert_Row()
Dim nRows, R
Application.Scree
Hi Experts
Here is my issue about inserting raws in a range of cells.
A B C
1 ABC ALPHABETS =IF(B1<>B2,1,"")
2 123 NUMERICS
3 *@& SYMBOLS
I want to insert a raw if the cell value in column B = 1.& copy the
text of column B & paste it in
Here you go.
The technique it uses is a FileSystem object.
It creates a SubFolder collection and processes each
folder in the Subfolder collection.
In each of these folders, it creates a Files collection
and processes each file in the collection.
Paul
'
Curious...
Actually, the Activecell object is not necessary.
I changed it to:
If Range("A"&i) = "" then exit sub else
and it worked just fine.
BTW:
I changed the loop to:
Application.ScreenUpdating = False
For R = 1 To 1000
If (Range("A" & R).Value = "") Then Exit Sub
StrArray = Split(
you can do that too . you can add sheet name to be merged in the any cells
On Fri, Feb 11, 2011 at 4:51 PM, shannu shannu wrote:
> one of the beautifull macro, but alas if i could specify sheet names
> from 2 diff workbooks to merged it would help me.
>
> Regards,
> Shahina
>
> --- On *Sun, 10
Paul as per below conversation the macro which you have can u please send me
so that i customize from my end.
Thanks,
Prathima
On Thu, Feb 10, 2011 at 10:55 PM, Paul Schreiner wrote:
> You've asked this question in an Excel VBA Macros user group.
>
> Do you not wish a VBA solution?
>
> Also, y
one of the beautifull macro, but alas if i could specify sheet names from 2
diff workbooks to merged it would help me.
Regards,
Shahina
--- On Sun, 10/31/10, Randhir Singh wrote:
From: Randhir Singh
Subject: RE: $$Excel-Macros$$ How to consolidate the data using macro
To: excel-macros@googl
First, Record a macro in which you open a file,
make the changes you require, then close the file.
Then, modify your macro like:
Sub Set_PrintArea()
Dim fso, FolderName, Fldr, Files, File, Ext
Set fso = CreateObject("Scripting.FileSystemObject")
FolderName = "C:\temp\files"
It seems you have Hijacked another discussion thead (begun by Nihal on Feb 5,
2011)
If you wish to begin a new query, please start your own topic.
Especially as this has absolutely nothing to do with passing variables to
functions!
Paul
From: Srinivasulu R
I take it that the name of the sheet is:
PRIPRAVA_PROJEKTA
??
In that case, you need to use:
Sheets("PRIPRAVA_PROJEKTA").select
without the (")'s, VBA interprets the string PRIPRAVA_PROJEKTA
as a variable name.
Since you aren't using "Option Explicit", then VBA allows you to
"define" variables
Any help. :-) will be appreciated.
--- On Thu, 1/27/11, Seba wrote:
From: Seba
Subject: Re: $$Excel-Macros$$ build a database from multiple workbooks
To: "MS EXCEL AND VBA MACROS"
Date: Thursday, January 27, 2011, 9:23 PM
Hi,
I made the following change for sheet name and I get the error
15 matches
Mail list logo
