Hi Excel_Lover,
When would you like the Req.No's to be generated? Should they be permanent
numbers once calculated, or can the be recalculated at any time (for example
with a formula)? Will the list always be sorted in the order you want used
for Req.No. logic?
Asa
From: excel-macros@
If the text is indeed identical, I have not heard of any problems with
comparison.
How are you comparing the text? With formulas, a macro, or some other
method?
One problem that comes up for people working with text in Excel, sometimes,
is that there are characters that LOOK identical, but
Hi Shekhar,
Either of these:
=ROUNDDOWN(A1,-3)
=MROUND(A1-500,1000)
If you wanted to round to the nearest multiple of 1000, instead of rounding
down, you could use either of these:
=ROUND(A1,-3)
=MROUND(A1,1000)
Functions used for/in rounding include:
ROUND
ROUNDUP
ROUNDDOWN
MRO
Hi Vaibhav,
You got some other good responses.
Here are versions that should be faster for large ranges, since it does not
have to loop through every cell in column A.
It has an important limitation, though: It will only work correctly if
there are at least two of every unique value in colum
Yeah, I don't see how you can avoid a loop (with many files to create).
However, you could do some optimization to avoid copying the whole table to
another range, removing the duplicates, then having to clean all that up,
along these lines:
SRC_RANGE.AdvancedFilter xlfilterinplace, unique:=tru
1:03 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ problem in copy paste
yes i have installed
On Tue, May 1, 2012 at 7:10 AM, Asa Rossoff wrote:
Hi Yasir,
Do you have Skype installed?
See
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/text-loses
-forma
Hi V.Kiran,
If you need to use an exact copy of the bank's form, it may be a bit tricky
in Excel. Whether to use Excel at all, and what approach to take if you
do, depends on the reason you are trying to undertake this.
For example, if you want to use an exact copy of the bank's form, and you
Hi Pascal,
I'm glad you found the problem (specifying the whole path with Getfile)
With late binding you don't need to set a library reference.
If you don't set a library reference, the constants aren't defined.
You can easily verify the values of the constants in the immediate window
like
Congratulations Rajan, you're very generous with your time and expertise!
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush Jain
Sent: Wednesday, May 02, 2012 9:01 AM
To: excel-macros
Subject: $$Excel-Macros$$ Rajan verma : Most Helpful Member- A
Hi Ashish,
Workbook protection.
http://spreadsheetpage.com/index.php/tip/spreadsheet_protection_faq1/
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ashish Pradhan
Sent: Wednesday, May 02, 2012 12:20 AM
To: Excel Macros
Subject: $$Excel-Macros$$ Hi
acros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Tuesday, May 01, 2012 7:42 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to
a text file
Hi Pascal,
Actually, my feeling is that your code is leaving a file handle open
unneccesarily an
Hi Pascal,
Actually, my feeling is that your code is leaving a file handle open
unneccesarily and you are having a file sharing/locking violation on FAT32
volumes -- since you only need to have one file handle open at a time, your
code should be correctable (unless VBSCRIPT has some strange bug).
Hi Dhanesh,
=SUMIFS(F3:R3,F2:R2,">="&B3,F2:R2,"<="&C3)
will total the periods whose date (as specified in row 2 -- appears to be
month-ending date) falls between the specified dates in B3 and C3.
=COUNTIFS(F2:R2,">="&B3,F2:R2,"<="&C3)
will count the number of periods that actually appear in
Hi Yasir,
Do you have Skype installed?
See
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/text-loses
-formatting-when-i-use-cut-copy-paste/0371d013-1e5a-4d2b-874f-792d34d16c61?a
uth=1 for more details and fix.
Asa
From: excel-macros@googlegroups.com [mailto:excel-mac
Hi Pascal!
Not sure what you mean by "optical hard drive" (HDs use electromagnetic
heads).
I have not had the chance to try your scripts, and I haven't relally played
with Scripting.FileSystemObject, but some quick thoughts for you--
File locking and permissions are controlled by the OS and
Hi Anil,
How to copy multiple sheets between workbooks:
https://office.microsoft.com/en-us/excel-help/move-or-copy-sheets-HP00520146
9.aspx
How to create linked cells:
http://www.keynotesupport.com/excel-linking-worksheets.shtml
How to create a QueryTable:
http://www.dicks-clicks.com/excel/Extern
If you don't want to open the other workbook and you don't want to usa VBA,
I don't know how to COPY a worksheet from one workbook to another, but you
can link to desired values.
For example, in cell A1 of your destination sheet/workbook, type:
=[OtherWorkbookName.XLS]Sheet1!A1
To rerieve
Not on Google, but here is a list that last I was on it had an excellent
group of people:
http://www.lsoft.com/scripts/wl.exe?SL1=ACCESS-L&H=PEACH.EASE.LSOFT.COM
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anil Kumar
Sent
cro event
Hi Asa,
Thanks for quick reply,
can you please provide me code for the same, see I wanted to show message
whenever sheet calculating or saving data and message userform must hide
automatically.
Thanks
Vijay
On Thu, Apr 26, 2012 at 11:09 AM, Asa Rossoff wrote:
Hi Vijay,
How
You can go to:
https://groups.google.com/forum/#!forum/excel-macros
Then sign in to Google using the email address you want to add (create an
account if needed).
Then, click the "Join group to post" button.
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@
Happy Birthday Ayush! Hope it's an excellent one.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Wednesday, April 25, 2012 6:49 PM
To: excel-macros@googlegroups.com
Cc: Ayush Jain
Subject: $$Excel-Macros$$ Happy Birthday Ayush
Hi Vijay,
How about a userform with your "busy" message? You could either have the
userform's code perform the task (save, calculate,.) or if you want to
perform that task from outside the userform, set the userform's ShowModal
property to False so control will return to the procedure that displa
Hi again Anil,
I made suggestions for Worksheet_Change in another post, but I see that you
included your EnclosureAdd routine in your original message, so I will offer
you a revision to EnclosureAdd that takes a Range parameter instead of a
string parameter. This is more efficient and also solves
modules are in
the future somewhere.
On Mon, Apr 23, 2012 at 1:31 PM, Asa Rossoff wrote:
> The more modular you oranize things, breaking things into small tasks, the
> likelier that this kind of issue will naturally be avoided.
>
> Another potential solution is to use a class module
g the final version pretty.
On Mon, Apr 23, 2012 at 12:59 PM, Asa Rossoff wrote:
> If you use a separate sub or function for the tasks that could apply to
one
> or the other array, VBA will by default actually pass the array "by
> reference" and you have a single name to refer to
know this in advance.
The easiest thing seems to be to just create a third copy which will
be a copy of one or the other depending on the condition. That way I
replace an array name in about 20 places but the indexing all stays
consistent across all 3 arrays.
On Mon, Apr 23, 2012 at 12:40 AM, As
Usually I would use one array. Arrays can hold lots of data, but they are
not objects, and so cannot have multiple references. You could
theoretically "hack into" the data for a new variant and point it to the
same array using the Windows API, but this seems like a dangerous idea to
me. VBA work
zad
On Sat, Apr 21, 2012 at 4:30 AM, Asa Rossoff wrote:
Hello Divaker!
You provided very little information about your need.
My reading of the subject line of your message ("Count initial #NA in a
row.") leads me to believe you would like a formula that:
1. Finds the first appe
I don't think Empty will have any more effect than ClearContents...
.UsedRange=Empty means .UsedRange.Value=Empty -- it is only clearing
values, same as ClearContents. .Delete removes the range from .UsedRange
entirely.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel
n usedrange but exactly
the same number of rows.
After clearing or deleting the contents of currentregion and then
loading in a new set of data
with fewer rows than before, the row count of usedrange is still the
same as before.
On Wed, Apr 18, 2012 at 4:25 PM, Asa Rossoff wrote:
> UsedRange incl
UsedRange includes the intersection of all rows with used cells and all
columns with used cells. In other words, UsedRange is always a rectangular
range.
CurrentRegion based on a cell with a value in it also returns a rectangular
range. RANGE.CurrentRegion returns a RANGE that includes the sp
Must be sending to all contacts. I believe it's some kind of
solicitation--obviously misdirected--but based on info so far (3 of these
emails in 2 days, hasn't responded to list questions about the messages), I
think resumeske...@gmail.com should be banned without further ado.
From: excel-macr
Dear N.Sundarvelan,
I found the following by going to TOOLS->Customize->Keyboard in LibreOffice
(should be similar to OOo):
ctrl-shift-;current time (date and time, formatted to show time)
ctrl-;current date (date and time, formatted to show
date)
ctrl-shift-+
no, this is not a safe hour to determine safety of code. I was thinking "Do
Until" even as reading "Do While".. yours, you're right, has that edge case
issue.
The API should do the trick without adding complexity.
Asa
From: Asa Rossoff [mailto:a...@lovetour.in
midnight... but I could just break.
On Mon, Apr 16, 2012 at 11:57 PM, Asa Rossoff wrote:
Try setting a watch with "break when value changes", then keep hitting F5 to
resume execution after checking the current value (assuming it breaks for
you). You may find that the value of ma
pr 16, 2012 at 11:57 PM, Asa Rossoff wrote:
Try setting a watch with "break when value changes", then keep hitting F5 to
resume execution after checking the current value (assuming it breaks for
you). You may find that the value of maxrow is never set to 111, even if it
eventually surpas
testing I will slow it down.
Thanks yet again.
On Mon, Apr 16, 2012 at 10:53 PM, Asa Rossoff wrote:
Hi Howard,
The watch should be setup like this, in the Add Watch window:
Expression:maxrow = 111
Context -
Procedure: (procedure with maxrow in scope)
Module:
Hi Deba,
Perhaps some of Chandoo's dashboard resources are of interest. He also
offers online classes and seminars at various real worl locations:
http://chandoo.org/wp/excel-dashboards/
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deba Ranj
Hi Howard,
The watch should be setup like this, in the Add Watch window:
Expression:maxrow = 111
Context -
Procedure: (procedure with maxrow in scope)
Module: (module with above procedure)
Watch Type: Break When Value Is True
If you look in the watch wind
ets(ContangoSource).UsedRange,
Sheets(ContangoSource).Columns(ConDate))
with this
Set InputRange = Sheets(ContangoSource).UsedRange.Columns(ConDate)
=====
On Mon, Apr 9, 2012 at 3:38 AM, Asa Rossoff wrote:
>> contangoindex = _
>>
eturning the entire
spreadsheet?
yeah all the rest was there. Still confused though. He supposedly
does without SET what I cannot do unless I use SET.
On Sun, Apr 15, 2012 at 7:25 PM, Asa Rossoff wrote:
> Your code is fine except it doesn't do what the comment says it does :) --
> un
it only works if I use the SET. Otherwise it will not compile.
' First let's copy everything we need into an array for efficiency
With Sheets(RawData)
Set tmprange = .Range(.Cells(2, BarOpen),
.Cells(.UsedRange.Rows.count, EContango))
End With
On Sun, Apr 15,
ut.
I suspect the effect is small at this scale though. 4K X 8 colums vs
100K X 50 so just .6% of the data volume
he tests.
On Sun, Apr 15, 2012 at 2:27 AM, Asa Rossoff wrote:
> Just came across a simple example using an array to manipulate cell
values,
> then put only values that got
Perfect timing!
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Sunday, April 15, 2012 6:07 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett
Thanks to all who have respond
Just came across a simple example using an array to manipulate cell values,
then put only values that got changed back to the worksheet. It also has a
range/index equivalent sample, and a range/selection/offset example (this is
often the sort of thing first-time macro writers end up with after mod
Hi Kenrock,
If I understand you correctly, you could get a sort to work by copying
column A, paste-special, Values (Select Col.A/Ctrl-C/Alt-E,S,V,Enter), then
perform your sort.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of kenrock
Sent: Saturd
Congratulations Don! Well deserved, glad to see you get this recognition.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush Jain
Sent: Saturday, April 14, 2012 1:36 AM
To: excel-macros
Subject: $$Excel-Macros$$ Most helpful Member - March 12-
sheet which
is not Sheets(RawData)?
On Sat, Apr 14, 2012 at 5:58 PM, Asa Rossoff < <mailto:a...@lovetour.info>
a...@lovetour.info> wrote:
> Not illegal, but --
>
> You didn't qualify Sheets or either instance of Cells in your problem line
> of code.
>
Not illegal, but --
You didn't qualify Sheets or either instance of Cells in your problem line
of code.
That line, as written, requires two things to be true to work correctly:
1. The active workbook is the workbook that hold the named sheet. You
could avoice that with ThisWorkbook.She
t: Re: $$Excel-Macros$$ Ok I know I should be getting this by now but
why does this assignment not work?
Ah, that example was the perfect explaination. Thanks as always and
sorry about the rough day.
Hope you have a great weekend.
On Sat, Apr 14, 2012 at 12:38 AM, Asa Rossoff wrote:
> Cells does
th is outside the assignment then Cells becomes a
member
of the sheet object?
On Sat, Apr 14, 2012 at 12:25 AM, Asa Rossoff wrote:
> The first cells has a leading period… which mean it is a member of the
> object you are WITH.. but today you are alone, are are not WITH any
object,
> subject,
The first cells has a leading period. which mean it is a member of the
object you are WITH.. but today you are alone, are are not WITH any object,
subject, friend, or foe.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of tangledweb
Sent: Saturday, April 14
Hi Matt,
I am not doing much programming these days, and I don't have a super expert
answer for you.
.But I imagine there might be some use in a class for each field -- if
anything though, I would think the first and most useful step might be to
create a class for your database (something akin
groups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Apr/Thu/2012 12:33
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Argh. Previously posted evaluate function
replacing loop has unnoticed major error
> Agree row and column is not a worksheet concept
use I saw exampls on
the web like evaluate("sin(45)") which I considered morally
equivalent.
I guess not. So what do you think adding the ROW(), here is doing
exactly? It does work for me too.
On Thu, Apr 12, 2012 at 12:21 AM, Asa Rossoff wrote:
> Heck,
> IF(ROW(),ROUND(ra
Heck,
IF(ROW(),ROUND(range))
works.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Thursday, April 12, 2012 12:13 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Argh. Previously posted
x27;ve done it again. Funny I tried to use round on a
range in the worksheet too I could not get it to work.
Putting the round into a vacant cell of course would not work and I
could not figure out how to have it operate on
the existing cells in place.
On Wed, Apr 11, 2012 at 7:13 PM, Asa Rossoff wr
e
a new copy anyway I see no reason all dimensions can not change.
It really makes no sense to say you can increase all dimension if tossing
the
contents but not if keeping them. Somebody took an implementation shortcut.
On Wed, Apr 11, 2012 at 8:32 PM, Asa Rossoff wrote:
>> So if redim pres
7;t
know).
Yes, for a two dimensional array, transposing should let you redim the other
dimension, and transposing again will get you your originial array
arrangement with the preserved data. At the cost of copying the array in
memory twice.
Asa
-Original Message-
From: Asa Rossoff [mailto:a...@lov
Just curious how you ever even thought of trying the double transpose.
On Wed, Apr 11, 2012 at 6:51 PM, Asa Rossoff wrote:
>> Whatever would make you think of it that being the case?
> Sorry, makes me think of what being the case?
>
> -Original Message-
> From: excel-macro
one would want, can you
transpose the array, do the redim, then transpose back?
On Wed, Apr 11, 2012 at 6:10 PM, Asa Rossoff wrote:
> rounding a range results in an array. Evaluate evaluates array formulas
and
> returns array results. So, the fact that it didn't with the simple ROUN
As you suggested in another post, yes, if you transpose the array you should
have an array with rows and columns switched allowing you to redim the rows.
Another potential solution is to dimension your output array without the
preserve option, and just use the maximum number of rows (probably t
swer to my other new post about redim
preserve?
On Wed, Apr 11, 2012 at 5:53 PM, Asa Rossoff wrote:
> To retrieve a multi-column array I resorted to
> "transpose(transpose(round(a1:b10,2)))" form.
>
>
>
> From: Asa Rossoff [mailto:a...@lovetour.info]
> Sent: Wednesday, A
To retrieve a multi-column array I resorted to
"transpose(transpose(round(a1:b10,2)))" form.
From: Asa Rossoff [mailto:a...@lovetour.info]
Sent: Wednesday, April 11, 2012 5:18 PM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Argh. Previously post
imed value2 vs value and got zero difference but only
20k cells may not be enough
to see a difference.
Since the array method was only slightly slower than this perhaps I
should use that and use the
array for the rest of my processing too which I was already considering.
On Wed, Apr 11, 2012 at
Hi Howard,
Seems like an Excel bug.. Sorry for not testing the suggestion. Evaluate
may not be fully documented for a reason. However, it is a great useful
function, just if you aren't getting the result you expect, you may have to
look for a workaround. I just posted a query in a developers fo
Hi Ratedr,
Almost all automation requires a macro to implement (I say almost because
some features like conditional formatting, data validation, and comments
that appear when the mouse hovers over a cell could be looked at as types of
automation).
So this will will likely require a small macro.
The reason you can't call a method (sub or function member of a class)
directly is because the object defined by the class doesn't exist until you
create it with the NEW keyword (or CreateObject - but usually you should use
NEW).
It doesn't exist for a reason - each time you use the NEW keyword
umber format:
[<-10]-"Rs."#\,##\,##0;[<10]"Rs."#,##0;"Rs."#\,##\,##0
I did test saving and re-opening a file with this method, and there are no
problems.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Beha
I think it should work to give the right comma separation, but it does not
round to Lakhs.
For Lakhs plus Indian comma separation, try this one (tested in Excel 2010):
[<-100]-"Rs."#\,##\,##0,,,%%;[<100]"Rs."#,##0,,,%%;"Rs."#\,#
#\,##0,,,%%
This one also supports negative numb
Hi Matt,
Glad to help. What was your solution? Moving the functions to a standard
module instead of the class module?
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Matt
Sent: Tuesday, April 10, 2012 6:03 PM
To: excel-macros@googlegroups.com
S
ith
End Function
' parameters/arguments in VBA default to ByRef - see SUB/FUNCTION in Help
' widget here is actually the calling procedure's variable
Sub ModifyWidgetWithASub(widget as widget)
With widget.features
.feature1 = .feature1 / 2
.feature2 = .feature2 * 2
had
a solution but
will try to be more proactive about that. Nothing proprietary to
worry about but the length
can be a problem at times.
On Mon, Apr 9, 2012 at 1:09 PM, Asa Rossoff wrote:
> Hi -
>
> Actually.. I think you asked this question previously. From your
> descript
te the range available to other procedures?
>
> On Mon, Apr 9, 2012 at 2:35 AM, Asa Rossoff wrote:
>>> This works. Is there a reason why it is not better?
>> Yes. It won't always work. RANGE.Columns is relative to that range (as
is
>> RANGE.Rows, RANGE.Cells, and
Hi -
Actually.. I think you asked this question previously. From your
description, I'm still not sure you understand.
It all comes down to the object model. WorksheetFunction is not a property
of Worksheet. WORKSHEET.WorksheetFunction is never valid.
WorksheetFunction is only a property of Ap
ough Help
describes the argument as an array, it may well perform best if you just
pass the range reference (no .value at the end). That way it can decide how
to handle the data best for itself. The most important issue was to limit
the size of the range properly.
-Original Message-----
From: As
l document it well and write it as
> well as I can but I am sure that will mean my style is most likely to
> be more procedural than object oriented to its best use. Unfortunate
> but reality.
>
> I am sure I will call on you again though as you have been quite
> helpful and no g
ll on you again though as you have been quite
helpful and no good deed ever goes unpunished :)
On Sat, Apr 7, 2012 at 10:22 PM, Asa Rossoff wrote:
> It was type mismatch
>
> Oh, well. VBA is interpreted (when compiled it compiles to a bytecode,
not
> executable code) so as a matter o
probably as efficient as you
can get so I think I will stop chasing this greased pig.
Thanks for all the help. I will still go back and look through the
debug links and look for the other references you mentioned.
On Sat, Apr 7, 2012 at 10:04 PM, Asa Rossoff wrote:
> I tried this little variati
> Now seriously take a break.
You're right :)
However, no, others often know things that stump me. And my knowledge is
superficial in some areas, and I make assumptions..
ttyl :)
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread ti
nputRange.Value
' Determine where the index in ContangSource is of the first date
that matches the first date in RawData
contangoindex = WorksheetFunction.Match(Sheets(RawData).Cells(2,
BarDate).Value, CellsOfInterest, 0)
On Sat, Apr 7, 2012 at 9:17 PM, Asa Rossoff wrote:
> You don't
ContangSource is of the first date
that matches the first date in RawData
contangoindex = WorksheetFunction.Match(Sheets(RawData).Cells(2,
BarDate).Value, CellsOfInterest, 0)
On Sat, Apr 7, 2012 at 9:17 PM, Asa Rossoff wrote:
> You don't need to know in advance the size of your output a
is no apriori way to know how many rows
there will be.
On Sat, Apr 7, 2012 at 8:56 PM, Asa Rossoff wrote:
> Another one I started typing didn't finish and send.
>
>> (5) In your rawdata loop, there is no need for parenthesis around
>> the boolean expression. VBA wil
fully more than trivial out of book snippets? I learn best by
looking
at lots of examples.
On Sat, Apr 7, 2012 at 8:35 PM, Asa Rossoff wrote:
> I just checked the help for WorksheetFunction.Match; the second argument
is
> specified as an array, not a range.
>
> You may be running
utColumnCount set during
population of that array...
Set OutputRange=Sheets("sheetname").range("a1").resize(OutputRowCount,
OutputColumnCount)
OutputRange.Value = OutputArray
Off for the evening,
Take it easy,
Asa
-Original Message-
From: excel-macros@googlegrou
lls(2,
ConDate).Value, Sheets(RawData).Columns(BarDate), 0)
gave Unable to get the match property of the worksheetfunction class
On Sat, Apr 7, 2012 at 4:19 PM, Asa Rossoff wrote:
> The term reference in Excel, when referring to a cell or range, means the
> textual description of that cell or
ConDate).Value, Sheets(RawData).Columns(BarDate), 0)
If you want to keep helping I am glad to have it because I am
basically trying pseudo random things to debug and so far have only
solved one of the 3 problems today myself.
On Sat, Apr 7, 2012 at 5:09 PM, Asa Rossoff wrote:
> On Worksheet.
Loop
On Sat, Apr 7, 2012 at 8:08 PM, Asa Rossoff wrote:
> Hi Howard,
> With objectname
> Only takes effect in specific instances of using a leading ".". Nothing
> else in the with block is effected. It's an "anonymous" (no variable
name)
> equivalent
nction.Match(Sheets(ContangoSource).Cells(2,
>> ConDate).Value, Sheets(RawData).Columns(BarDate), 0)
>>
>> If you want to keep helping I am glad to have it because I am
>> basically trying pseudo random things to debug and so far have only
>> solved one of the 3 proble
to get the match property of the worksheetfunction class
>
> On Sat, Apr 7, 2012 at 4:19 PM, Asa Rossoff wrote:
>> The term reference in Excel, when referring to a cell or range, means the
>> textual description of that cell or range (the Address property of a
range
>> ob
r index = startrawdata To stoprawdata
If (Sheets(RawData).Cells(index, BarDate).Value =
Sheets(ContangoSource).Cells(contangoindex, ConDate).Value) Then
Sheets(RawData).Cells(index, EContango).Value =
Sheets(ContangoSource).Cells(contangoindex, Contango).Value
Else
c
ental issue.
On Sat, Apr 7, 2012 at 3:13 PM, Asa Rossoff wrote:
> p.s. other methods of identifying the real data besides .currentregion
are:
> 1. Range.End(xlup) and range.end(xlleft) (lookup range.end in help)
applied
> to the last cell at the extent of the entire worksheet in a used c
rse there is no row 0.
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Saturday, April 07, 2012 3:18 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ runtime error on assignment trying to f
startrawdata =
WorksheetFunction.Match(Sheets(ContangoSource).Cells(2,
ConDate).Value, Sheets(RawData).BarDate, 0)
where Condate is a column and BarDate is a column and hopefully
Sheets(RawData).BarDate returns that column as the range for the
Match.
On Sat, Apr 7, 2012 at 2:53 PM, Asa Rossoff wrote:
> n
integer type only goes to 32768 - use long
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Saturday, April 07, 2012 2:53 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ runtime error on assignmen
that worksheetfunction needs a particular sheet?
ConDate and BarDate are column names and this concept seems to work
elsewhere
but not sure if Sheets(RawData).Bardate really returns that column as a
range?
On Sat, Apr 7, 2012 at 2:30 PM, Asa Rossoff wrote:
> you should highlight the entire rows (
names and this concept seems to work
elsewhere
but not sure if Sheets(RawData).Bardate really returns that column as a
range?
On Sat, Apr 7, 2012 at 2:30 PM, Asa Rossoff wrote:
> you should highlight the entire rows (and same for extra columns),
> right-click, delete
>
> the delete key wo
you should highlight the entire rows (and same for extra columns),
right-click, delete
the delete key won't cut it (clears the text and formulas but leaves
formats)
or I select those rows/columns, then Alt-E,D
if selecting some cells but not entire row/column, you can delete entire row
with Alt-
Hi Lokesh,
Are you asking for information about online classes?
If so, you might be interested in:
http://chandoo.org/wp/vba-classes/
http://academy.excelhero.com/excel-hero-academy-tuition/
http://www.ozgrid.com/Excel/free-training/basic-index.htm
Not strictly web-based:
http://www.mr
Charlie,
Did you see the solution I posted for you?
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Cab Boose
Sent: Friday, April 06, 2012 3:53 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Deleteing Rows based on single column conte
101 - 200 of 393 matches
Mail list logo