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
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 =
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 mahes...@gmail.com wrote:
Dear All
In attach sheet i want to find matching text from another column, Can
anyone help for
formula.below
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 -
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
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
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 /
-- Forwarded message --
From: sudhir kumar bluecore...@gmail.com
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
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
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,
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
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
problem solved thanks
On Nov 30, 9:34 pm, pete sq...@netspace.net.au 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
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 nor...@gmail.com wrote:
Try the following formula in cell C11
=IF(ISNA(VLOOKUP(A11,E2:F6,2,0)),Not
Can any one help me...I need this very urgent..
Thanks...
-- Forwarded message --
From: bala Subrahmanyam puligadda simplyb...@gmail.com
Date: Sat, Nov 28, 2009 at 12:00 PM
Subject: $$Excel-Macros$$ Help required in repeating calculation using macro
To:
you have copied it from pdf file can u send that tooo
On Mon, Nov 30, 2009 at 4:28 PM, amresh kumar amreshkushw...@gmail.comwrote:
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
--
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 I
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
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
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 Looping
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
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
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
This
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 Team,
Could anyone of you provide me the solution? Thanks in advance.
Regards,
Yogesh Kudva
On Nov 23, 9:54 am, Yogesh V. Kudva yogesh_ku...@rediffmail.com
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
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
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
davebonall...@hotmail.comwrote:
Hi,
Try doing it manually with
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
28 matches
Mail list logo