I'm currently developing an excel spreadsheet that uses vba macros to
print and email the ms excel workbook.
Throughout our organization, due to other applications w/n the
organization, all of our users have their Macro Security settings set
to High and VB as a trusted publisher. Becasue of this
Hi,
Does anybody have an ppt presentation on introduction to excel 2003. i have
prepared one but its not that effective. can somebody help me by mailing me
the ppt if u have with u .
Regards Lingesh
--~--~-~--~~~---~--~~
--
Hi
I'm looking for a ppt presentation on "introduction to excel 2003". is there
any one who can help me in this regard. if any one have an ppt on this can
mail me across or guide me to the site where i can download it.
Thanks for the strain and stress
Regards... Lingesh
--~--~-~--~~
Hi Ashish,
Thanks for your reply,
This code is working fine, but if I enter value apart from "bp" all the
sheets should be protected. Please let me know the code for this.
On Tue, Mar 24, 2009 at 9:42 PM, Ashish Jain <26may.1...@gmail.com> wrote:
>
> Hi Suresh,
>
> Remove the 8th line from you
Hi
See if this helps
http://134.198.33.115/webworks/Excel.05.ppt
Ashish
On Wed, Mar 25, 2009 at 10:44 AM, lingesh p wrote:
> Hi
>
> I'm looking for a ppt presentation on "introduction to excel 2003". is there
> any one who can help me in this regard. if any one have an ppt on this can
> mail
2009/3/23 Puzzled bkm...@aol.com
>
> Does anyone know how to have excel automatically do this without
> having to recopy the equations?
>
Didn't see this answered, but have you ensured that the Automatic Recalc
option is enabled in the Excel preferences?
Tools -> Options -> Calculation Tab (In th
Dear All,
Please help me on said subjects . I attached sheet for same problem.
Thanks in Advance
Sachin Shukla
Business Analyst
New Delhi
--~--~-~--~~~---~--~~
-
Some important l
Hi all,
I need some help since i an beginner in vba programming
I have say an excel table as below:
1 2 3 4 5
2 3 4 5 6 6 78 8 9
hdg dg gdh gj
fsf
sf sfs sfs sf
in this table I have to count number of occupied cells in every row
in first row the result should be 5
In second row: 9
third row: 4
What I am trying to achieve is if row in column has a zero or error
then hide row, which is the easy part and I have managed to do that,
the issue is I have got it to ignore blanks which I want to happen,
however the finished product doesn't look right when this happens as
more than one blank row
How can i manage it with the If Selection.Cells(x, 8) ??? Can u please
explain?
Thanks
On 23 Mrz., 20:31, Tom Jeffries wrote:
> An Alternative Solution:
> Public Function IsAcct(code As String) As Boolean
> Dim Acct
> Dim Found As Boolean
>
> Acct = Array( _
> "AD", "AE", "A
Hiii...
Guys I have a worksheet with around 4 rows.. And I need a VBA code to
Export Each Row in a separate Text file, with specified delimiter . .
And all the files should be exported in a particular folder, Named on any of
particular cell in the row...
Thanks in advance.
Regards.
Anil.
-
Sachin,
Attached is your solution.
It is done by using conditional formatting.
Regards,
Norman May
On Wed, Mar 25, 2009 at 6:47 AM, Sachin Shukla wrote:
> Dear All,
>
> Please help me on said subjects . I attached sheet for same problem.
>
> Thanks in Advance
>
>
> Sachin Shukla
> Business Ana
Hi Sachin,
It was very simple...Just use Conditional Format feature...
Attached is the file wid solution..
Thanks!!!
ANISH
On Wed, Mar 25, 2009 at 4:17 PM, Sachin Shukla wrote:
> Dear All,
>
> Please help me on said subjects . I attached sheet for same problem.
>
> Thanks in Advance
>
>
> Sach
Hi Anil,
Do you mean to say, you want 4 text files...
And what do you mean by specified delimiter...
I can give you the code which wil seprate the rows in any number of files
but the file name would be same as file01, file02 file03 and so on
Please lemme know...if it's okay...
On Wed, Ma
Hi Lavanya
Use CountA function to solve your problem.
Assuming the data and formulas as below:
A BC D E F G H I
1 2 3 4=COUNTA
(A1:H1)Result would be 4
X M N12 32 za
The way you would do that using Excel functions would be
to use CountA (counts non-blank cells).
so, in VBA you can use:
Rowcnt = Application.worksheetfunction.counta(range(Cells(R,1),Cells(R,100))
From: xxx
To: MS EXCEL AND VBA MACROS
Sent: Wednesday, March
Hi,
I again request all group members to not provide the solutions
directly, please help the users by mentioning steps but don't provide
them with the solutions embedded in file. We've given liberty of
posting files, so that it'll be easy to understand the queries.
Let the world know that you kn
PLz tell me how to get rid of these bulk of mails.
On Wed, 25 Mar 2009 Paul Schreiner wrote :
>The way you would do that using Excel functions would be
>to use CountA (counts non-blank cells).
>so, in VBA you can use:
>Rowcnt = Application.worksheetfunction.counta(range(Cells(R,1),Cells(R,100))
Thank you ashish and paul
On Mar 25, 2:40 pm, Paul Schreiner wrote:
> The way you would do that using Excel functions would be
> to use CountA (counts non-blank cells).
> so, in VBA you can use:
> Rowcnt = Application.worksheetfunction.counta(range(Cells(R,1),Cells(R,100))
>
>
>
>
Hi all,
I work on this spreadsheet a few days a week every year (During March
of course). If I get enough of a response, I'll post it, but it
tracks 35 (Decided that was plenty) entries in a 64-team field. (A
lot like NCAA basketball - Hmmm).
If I get enough of response I'll post it. I'll al
Hi All,
Can anyone help on this error. Below is the code.
Private Sub ok_Click()
Dim a As Integer
a = Val(text1.Text)
If a = bp Then
For Each shts In ThisWorkbook.Worksheets
shts.Unprotect
ActiveWorkbook.Unprotect
UserForm1.Hide
End If
If Not a Then
ActiveWorkbook.Protect
For Each shts In
That box is alrady turned on. I really don't know why it won't
calcluate. I even changed the maximum iterations and maximum change
values but it still didn't solve the issue. Any other words of
wisdom?
On Mar 25, 1:35 am, Luke Tovey wrote:
> 2009/3/23 Puzzled bkm...@aol.com
>
>
>
> > Does any
Your first For Each loop doesn't have it's own "Next" statement,
so it's using the one from your SECOND For Each loop.
That puts the EndIf statement outside of the loop, so it stands alone.
Also, FYI...
You're Hiding UserForm1 once for each sheet in the workbook.
Once should be enough I would thin
Public Sub TEST()
For x = 1 To 5
If IsAcct(Cells(x, 8).Value) Then
MsgBox Cells(x, 8).Value & " is a valid account."
Else
MsgBox Cells(x, 8).Value & " is not a valid account."
End If
Next
End Sub
On Wed, Mar 25, 2009 at 8:27 AM, xmux wrote:
chk this
Regards
Harish Upadhyay
On 3/25/09, xxx wrote:
>
>
> Hi all,
> I need some help since i an beginner in vba programming
> I have say an excel table as below:
>
> 1 2 3 4 5
> 2 3 4 5 6 6 78 8 9
> hdg dg gdh gj
> fsf
> sf sfs sfs sf
>
> in this table I have to count number of occupied cel
Dear all,
Does anybody have presentations or list of tips for copst cutting mesures in a
company. If yes, please forward me the same.
Thanx,
Mc
Add more friends to your messenger and enjoy! Go to
http://messenger.yahoo.com/invite/
--~--~-~--~~~---~--~~
U can use conditional foramating.
On Wed, Mar 25, 2009 at 4:17 PM, Sachin Shukla wrote:
> Dear All,
>
> Please help me on said subjects . I attached sheet for same problem.
>
> Thanks in Advance
>
>
> Sachin Shukla
> Business Analyst
> New Delhi
>
> >
>
--
J.Gaurav
Asst. Manager
Mahindra logi
Try the following.
PIN: 5080-8120-6873
Thanks & regards,
|| Mudassar Ramzan | MIS Officer | WorldCALL Telecom Ltd | 061- 814-3999 | 0321
7325277 ||
- Original Message -
From: Kuldeep Vashishtha
To: excel-macros@googlegroups.com
Sent: Monday, March 23, 2009 1:11 PM
Subjec
28 matches
Mail list logo