Hello
book to start with
VBA For Dummies
This is the book am using am also novice in VBA, but everyday am
appreciating the power of VBA.
Cheers
On Wed, Mar 10, 2010 at 12:39 PM, sumanth kumar wrote:
> So How can master in VBA
> can you please advice any books to learn and master VBA
>
> On
Just to add to my message - instead of using the long code taht Shyam
provided, for the purpose of demostration, you can also use the
following code which I listed on my initial post:
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal
Target As Range)
Application.CutCopyMode =
I am running some code withuin Access 2003 that opens and manipulates
an excel workbook.
The problem that I have is that once in a while the workbook that I
get from our vendor (through FTP) is corrupt.
"The fils is not in a recognizable format"
How can I test for this before proceeding into my c
Hello Dear
You can use select to distinct.
If u want a proper macro for it reply me.
it is easy to select the distinct value only.
Assistance may be late,but we are helping our group after job.
Please Consider The Late Answer.
Happy to help
:)
Shyam
On Wed, Mar 10, 2010 at 8:17 PM, wora
Hello Dear
Thanks to provide us Explanation.
Actually i have cheked it for
ctrl c
ctrl v
ctrl x
i agree that anyonr cany use copy cut paste from formula bar.
i have to check it out.
thanks to provide me bug.
Happy to Help
:)
Shyam
On Wed, Mar 10, 2010 at 8:29 PM, Excel 009 wrote:
> Hi Shyam
Hello Dear
Offcorse there is a formula and function for it.
please write me me a perfect question.So that we
can help you to write a function and macro for it.
Better solution can be provided if specific feasibility and requirements
known.
Happy to Help
:)
shyam
On Wed, Mar 10, 2010 at 9
Venkat,
If 8:59:44 is in cell A1, try the following formula:
=SUM((HOUR($A$1)*3600),(MINUTE($A$1)*60),(SECOND($A$1)))
Norman
On Wed, Mar 10, 2010 at 9:02 AM, Venkatesan c wrote:
> 8:59:44 into Decemical seconds is there any formula anyone help me
>
> Thanks & Regards
>
> Venkat
>
> --
>
> -
The answer will depend largely on where you have this value and how it is
stored.
Excel doesn't store "time"
What it DOES is converts time to a fractional part of a day
(date is stored as the number of days since 1/1/1900)
so, 8:59:44 is converted to 0.374814814814815
and DISPLAYED as
8:59:44 AM
Hi Shyam and Paul,
Thank you for your input. The main problem I brought up is not the
user will not enable the Macro; it is how to clear the "copied" items
in the Clipboard pane programmatically.
Shyam, as I have mentioned prior, I did ran the macro and it works
well, but when the clipboard pane
Hi mono
You can use pivot table by set e-mail to row and select data to count then
you can copy only single e-mail that you wanted.
*or *
using simple macro mixed with pivo table like this
1. first you have to put you list in column A
2. Run macro as below code
Sub DeleteDuplicate()
Range
I atatched a spreadsheet. Try that.
On Mon, Mar 8, 2010 at 4:52 AM, sachinp1...@googlemail.com <
sachinp1...@googlemail.com> wrote:
> Hello Members, I want help regarding this in which we receive the data
> in below mentioned date period format.where we have to convert in
> actual dd/mm/ f
8:59:44 into Decemical seconds is there any formula anyone help me
Thanks & Regards
Venkat
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceld
There really isn't a way to ensure a user doesn't disable macros.
AND THERE SHOULDN'T BE.
Consider this:
Evil, destructive, phychotic individuals have embraced Excel and VBA
as a method to distribute viruses.
Microsoft has provided the opportunity to allow only macros from "trusted"
publishers.
Us
Hi Sachin,
Hope this formula works for you! If the Actual data is in ColA & Row 1
then the formula in red shud be entered in ColB&Row1..
=RIGHT(A1,2)&"/"&MID(A1,5,2)&"/"&LEFT(A1,4)
Thanks
Surya
On Mon, Mar 8, 2010 at 4:22 PM, sachinp1...@googlemail.com <
sachinp1...@googlemail.com> wrote:
>
Thanks !
Regards
Sachin
On Mar 8, 6:38 pm, rf1234 rf1234 wrote:
> Hello Dear
> date format 01/10/2009-31/10/2009 i.e
> date/month/year-date/month/year
>
> is not feasible.
>
> Hope It will Help
> Happy To Help
> :)
> Shyam
>
> On Mon, Mar 8, 2010 at 4:22 PM, sachinp1...@googlemail.com <
>
>
>
>
''
''Anothe User Can Play The Game
'suppose u send the another user a workbook
and it has a securit
Hello Dear
Suppose we have write a macro for book1 using excel 2003,
when we send it to another user who have excel 2007 or
if he Disable or not allowing the macro using
Tools->Macro->Security
then the problem occurs,best way is forcely run macro at
startup or openning mode of workbook.
Hope I
So How can master in VBA
can you please advice any books to learn and master VBA
On Mon, Mar 8, 2010 at 9:32 PM, Paul Schreiner wrote:
> If I follow your question correctly, you're asking: "why would I need
> vba?"
>
> the answer is directly related to time, and repetition.
>
> At our location
Hi All,
I need help in the attached file. Actually Column H, I, J, K, L, & M is
vendor name which i dont want to show. In row 6, 7, 8, there will be
only one code which i want to come automatically in Column G (Coding).
Please help.
Thanks,
Imran Khan
Project Control Engineer
KBR - Kellog Br
19 matches
Mail list logo
