Hi Excel masters,
I have created a macro for maintaining attendance.
In sheet 1 i have created a box, If i select Jan. It should go to 2nd sheet
and should show only those columns and rows.
And remaining all lines should be hided. But it is not working.
Any suggestions,,,
Many thanks
Regar
Hi,
You can use custom fromat to get that 09:00:00.
Regards,
Deepak Rai
On Tue, Dec 1, 2009 at 8:10 AM, Toddy wrote:
> I am trying to capture the time in a variable that I am using to
> populate as text into an email via Lotus Notes from Excel and VBA.
>
> When VBA picks up the value from the
Hi,
Please try this code, Hope this will help.
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Regards,
Deepak Rai
On Tue, Dec 1, 2009 at 10:03 AM, Dave Bonallack
wrote:
> Hi,
> Try doing it manually with the macro recorder on, the
Hi Gaurav,
We can use Macros & VBA for a vast uses. I am working as a Data Analyst so I
use macros & VBA a lot to automate my tasks so that I can save time.
One more thing macros & VBA are also use for accurate data. It is useful
for repeat tasks
.
On Tue, Dec 1, 2009 at 9:36 AM, gaurav rustagi wr
Hi Team,
Could anyone of you provide me the solution? Thanks in advance.
Regards,
Yogesh Kudva
On Nov 23, 9:54 am, "Yogesh V. Kudva"
wrote:
> Hi Team,
>
> I need help regarding the attached file.
>
> PFA the sample file in which I enter the data in the form and when I click
> on the Save butto
Hi,
I need a code which can authenticate and get the details from my mail server,
for Eg., when i enter a Name / Mail ID in a Cell "A1"
the code should connect to Mail server (Microsoft Mail exchange Server) AD;
and then retrieve the email ID, etc if found else it should throw a messge
(mig
Can any body explain use of macros in an excel sheet.
explain in details
thanks in advance
--
CA Gaurav Rustagi
Assistant Manager-Finance
The Bristol Hotel
Adjacent to DLF Qutab Enclave,
Phase I, Gurgaon-122002
Haryana
Mobile 93 13 19 82 81
Tel0124 2356030, 435
Fax 0124
I am stumped with this one I have to do for work.
I have been trying to achieve the following without any luck.
This is what I would like.
In cell W7 If cells K7 M7 O7 = the letter d,a,n, or b count as 1
In cell L7 I would like if d a n appear in k7 show as 7 if the letter
b is in K7 show as 7.5
Hi,
Try doing it manually with the macro recorder on, then look at the syntax.
Dave.
> Date: Mon, 30 Nov 2009 10:05:31 -0800
> Subject: $$Excel-Macros$$ Run-time error '1004': PasteSpecial method of Range
> class failed
> From: jon.wester...@gmail.com
> To: excel-macros@googlegroups.com
>
>
I had almost completed my VBA project and then decided to convert it to
stand alone exe file using VB6 so that I can register my custom type data
files to have a specific Icon and enable them to be opened with my
application on doubleclick.
I have converted most of it successfully but just now I a
I am trying to capture the time in a variable that I am using to
populate as text into an email via Lotus Notes from Excel and VBA.
When VBA picks up the value from the worksheet, it shows as it's
decimal value. I then multiply the value to get a
time i.e. 0.375 *24 = 9. But I want this to be sho
YOUR CURRENT LINE 1 IS Worksheets("Sheet1").Activate
NOTE: "Sheet1" is the actual name of you work sheet
so if your other sheet's name is 'goodbye' then change the
code to
Worksheets("goodbye").Activate
you can also have the code loop through all (OR some of your
worksheets), by Loop
Hi Paul,
Thanks a lot for your help. It did help with accessing other excel
files that might be opened and used when the form is in use.
My new problem is that this form is always on top even if I go to
another excel workbook. Now I wonder if the file is really oppening in
a new instance of excel.
Based on the following description: "The Crystal Ball and CB Predictor
Developer Kits allow users to completely automate and control Crystal
Ball simulations and CB Predictor forecasts from within a VBA program
or any other language outside of Excel supporting OLE 2 automation.
The kits consist of
I have a set of data in Excel 2003 that is like this:
Customer OrderNum
abcdCust 234567
xyzzCust 12345678
...thousands of order entries, I'm just showing 2 taht are problems
for me.
The first customer needs to have a padded 7 digit order number as
"0234567"
The second needs a dash placed betw
This is something that seems pretty simple, I am trying to paste
values into a workbook using a macro:
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues
I start out by manually copying a range of cells in a separate
workbook and clicking a form button to paste the values. Each time
Does anyone know of a way in Excel 2003 or 2007 to restrict end-users
from viewing or editing VBA macros, but still allow them to enter data
in the spreadsheet and execute macros via a form button? Thanks.
--
--
Some
you have copied it from pdf file can u send that tooo
On Mon, Nov 30, 2009 at 4:28 PM, amresh kumar wrote:
> Hi My All Friends,
> please help me i want convert to attached image in excel format.if any
> solution please let me know ASAP
>
> Regards
> Amresh
>
> --
>
>
Can any one help me...I need this very urgent..
Thanks...
-- Forwarded message --
From: bala Subrahmanyam puligadda
Date: Sat, Nov 28, 2009 at 12:00 PM
Subject: $$Excel-Macros$$ Help required in repeating calculation using macro
To: excel-macros@googlegroups.com
Hi ALL,
Pleas
never mind. I figured it out myself.
The referenced cells were formatted as text (Rightclick > Format Cells
> Text). So, when the those cells were dereferenced, the referencing
cell's format was also changed to "Text". But when a cell formatting
is set to "Text", the reference no longer works...
Thanks Norman
but i want code in Column B
REG CODE CODE S Mahesh L1984 #N/A G Sudhir L1980 #N/A L1888 Manas
L #N/A Rakesh
L1982 L1985 Sohan
On 11/30/09, Norman May wrote:
>
> Try the following formula in cell C11
>
> =IF(ISNA(VLOOKUP(A11,E2:F6,2,0)),"Not Found",VLOOKUP(A11,E2:F6,2,FALSE)
problem solved thanks
On Nov 30, 9:34 pm, pete wrote:
> Hi Gurus
>
> I've set up the following sub which I want to use on other sheets (set
> up the same) in the same workbook. It's in a module (I tried putting
> it in the sheets & this workbook) - still learning/trying.
>
> Sub Interest()
> '
>
Hi Paul
Thanks a lot - what you've given works well & is much better than what
I had.
> but from there, you're jumping around the sheet.
> and copying info to the clipboard and pasting it.
> you don't need to do that.
This is also what Dave tried to point out, but I couldn't quite get it
to work.
I've been trying to follow your posts (all) and am
confused/disoriented/caffeine-deprived.
I think you need to get rid of the use of "ActiveCell"
or at least limit it's use.
let's take a look at what your code is doing.
first of all.
line 2 puts the word "Interest" in whatever cell you
currently
Hi Gurus
I've set up the following sub which I want to use on other sheets (set
up the same) in the same workbook. It's in a module (I tried putting
it in the sheets & this workbook) - still learning/trying.
Sub Interest()
'
' Keyboard Shortcut: Ctrl+i
'
1.Worksheets("Sheet1").Activate
Ac
Hi again Dave
I don't know how to attach a workbook. But I got it working, but not
quite as you had it.
Worksheets("Sheet1").Activate
ActiveCell = "Interest"
ActiveCell.Offset(rowOffset:=-1, columnOffset:=2).Activate
ActiveCell.Copy
ActiveCell.Offset(rowOffset:=1, columnOffset:=0)
Hi there,
I have a strange problem in Excel 2003 SP3:
when writing a reference to a cell on another worksheet like
SheetName!C98 or SheetName!$C$98
sometimes Excel does not display the referenced cell's value but
instead displays the reference formula SheetName!C98.
If I copy a working referencin
-- Forwarded message --
From: sudhir kumar
Date: Nov 24, 2009 7:36 PM
Subject: Requrest
To: excel-macros@googlegroups.com
hi
all experts and learners
Please note that your queries and answers should type
in attachement also. and it benefits for users to solve question
later th
What you're looking for here is a thing called "modality".
What it EFFECTIVELY means is that the "mode" of the user form
is tied to the workbook.
if you look at "help" for the Show command, you'll see that the syntax is:
[object.]Show modal
Where "modal" is basically true/false, or:
vbModal
I have a few recommendataions for you.
First:
You didn't mention which version of Excel you are using.
If it's Excel 97 (2003) then you have 65,536 rows.
If it's Excel2007, then you have 1,048,576 rows.
Range("n:n") tells your macro to process ALL rows.
so
Hi Janet,
If you are using XL2007, then the range you are seleceting contains about 1
million cells, so this code will take a while.
If your data doesn't actually go to the end of Column N, you could speed it up
considerably by changing your first line to:
Range("N2:N2").Select
If this range
Hi Pete,
You can't use the offset function with only 1 thingy. ie Offset(, 2) is
incorrect syntax.
If you don't want any Row offset, then you would need: .Offset(0, 2)
I can't quite figure out how your data is set out. Can you describe it to me,
or can you attach a sample workbook?
Regards - D
Try the following formula in cell C11
=IF(ISNA(VLOOKUP(A11,E2:F6,2,0)),"Not Found",VLOOKUP(A11,E2:F6,2,FALSE))
On Sun, Nov 29, 2009 at 10:15 AM, mahesh parab wrote:
> Dear All
>
> In attach sheet i want to find matching text from another column, Can
> anyone help for
> formula.below mention for
Hello Guys
I have created a useful code for my work, see below. but the problem: This
code takes almost 3minutes
to complete running. can anyone help me tweaking this to work much better.
Sub UseColorz()
Range("n:n").Select
For Each Cell In Selection
If Cell.Value > 0.02 And Cell.Value
Hi Dave
Thanks for helping out - I see how you've shortened the code - it's
much better but unfortuneately your correct re overwriting my formula.
My starting ActiveCell is B4 & I've amended line 3 of the code to:
ActiveCell.Offset(-1, 3).Copy ActiveCell.Offset(, 2)
but it's just copying the form
35 matches
Mail list logo
