] *On
Behalf Of *tangledweb
*Sent:* Tuesday, June 26, 2012 8:47 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Can I get the day of the week (e.g. Friday)
from the date already encoded in a string?
If I already have Sheets(RawData).Cells(count, BarDate).Text having
Thanks Asa and belatedly Noorain. The format function worked and as it
happens the other method was returning the wrong day for all those who
might use it.
The .value2 does not seem to be necessary but I left it anyway.
On Wednesday, June 27, 2012 10:09:16 PM UTC-7, tangledweb wrote:
Asa
out of range but worked fine with the alias.
On Tuesday, June 26, 2012 8:47:02 PM UTC-7, tangledweb wrote:
If I already have Sheets(RawData).Cells(count, BarDate).Text having a
value like 6/26/2012 is there a way to get the day of the week as a number
or string for that date that does
If I already have Sheets(RawData).Cells(count, BarDate).Text having a value
like 6/26/2012 is there a way to get the day of the week as a number or
string for that date that does not require splitting it into its parts and
feeding them to some function? If the latter the .net examples I found
:08 PM UTC-7, Lalit_Mohan wrote:
Hi,
You can try this
=TEXT(DAY(A1),)
Hope it helps you
Regards,
Lalit Mohan
On Wednesday, 27 June 2012 09:17:02 UTC+5:30, tangledweb wrote:
If I already have Sheets(RawData).Cells(count, BarDate).Text having a
value like 6/26/2012
to be what it wants.
On Tuesday, June 26, 2012 9:30:29 PM UTC-7, Lalit_Mohan wrote:
Hi,
You can try this
Evaluate(=TEXT(DAY(A1),))
Hope it helps you
Regards,
Lalit Mohan
On Wednesday, 27 June 2012 09:45:46 UTC+5:30, tangledweb wrote:
This seems to be designed to work
If I have 2 identical sized arrays and if a condition is true then I want
to always get values from one array and if the condition false from the
other array,
can some pointer be set to handle this using one array name and not test
for every assignment if true or false?
all arrays below
I am doing many tests on columns of date pasted into a sheet. Sometimes
more rows, sometimes less.
It is important that I be able to define the working range as just what has
data in it. However when I use
clear or delete on the usedrange or currentregion or any other way to
define it
I set a watch with maxrow=111 and set to break if true.Program runs and
in the watch window shows maxrow=111though also some odd message about
out of context but it does not break. Program runs to the end. Thoughts?
Also while the program is running it is filliing in several
I assume this has to do with the assignment being to a variable that is
passed into the function, but if so is there something more
elegant than using a temporary copy for the maxrow value passed in or
making it global? The function needs to know the value
of maxrow on entry and needs to
This works
With Sheets(RawData)
Set tmprange = .Range(.Cells(2, BarOpen), .Cells(stoprawdata,
EContango))
End With
but this which seems equivalent to me does not work
Set tmprange = Sheets(RawData).Range(.Cells(2, BarOpen),
.Cells(stoprawdata, EContango))
which gives
Program has already by error time successfully called 3 procedures doing
all the initialization work across 3 different sheets.
But then... application defined or object defined error
This has already successfully executed
With Sheets(RawData)
Set tmprange = .Range(.Cells(2,
I want to use an array to store values as more efficient that doing it cell
by cell,
then copy the entire array into the sheet range when done. But the size of
the
array not know initially. I do know that number of columns, but not the
number
of rows. So I will have to do some redim
I used the evaluate function below to replace the commented out loop
portion for better performance in rounding off all the cells in a range.
It was certainly fast and it performed the round function correctly but it
also replaced every single cell in the range with the value of the first
cell
I am trying to get more used to using ranges instead of addressing
individual cells by indexes. The loop below is rounding off the entries in
all the columns
where BarOpen for example is just the column index in the sheet. Is there
a way to do this more efficiently by using the used range
I would like to have a userform on a data sheet for setting parameters and
controls.
But if that useform is considered part of the range by the usedrange
function then I will
have to put it on a separate sheet which would be something of a pain.
--
FORUM RULES (986+ members already BANNED for
Sigh, the things I know I don't know are increasing faster than the things
I know.
I get a 1004 error on the assignment to stoprowdata below. Sheets(RawData)
has been used successfully before so I do not think that is wrong. So I
assume the problem is
in the rest of the statement. But if so
This statement is returning 99 though I deleted everthing below the
actual data to make sure no cells below it were used
stoprawdata = Sheets(RawData).UsedRange.Rows.Count - 1
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
Before running a program that puts the results onto a sheet I want to clear
that sheet from the previous run.
Easy to just clear a huge range, but really wanted to do it right and clear
the used range. I tried to find a way to use the usedrange value but could
not determine how to exclude the
If I want to find all the properties (if that is the correct word) for an
object how do I do it? Excel help just gives simple examples. In the
ones I wanted intellisense did not help.
Right mouse on the word gave an option to list all properties and methods
but when clicked nothing happened.
I have one sheet of raw data with several columns and thousands of rows.
I need to process this and I wanted to put the results on a separate sheet
with several columns and dozens of rows when done. I saw some example
code where it seemed you could do this as long as you qualified the sheet
it is
wanting to treat it as data)?
On Saturday, March 24, 2012 9:46:29 AM UTC-7, tangledweb wrote:
Excel keeps wanting to override me and make row 1 be column headers but in
a particular case I need it to be just data. Any way to force this?
--
FORUM RULES (986+ members already BANNED
Thanks, that works.
On Friday, March 23, 2012 12:41:57 AM UTC-7, Asa R. wrote:
Hi H.,
Not sure how you are determining that Excel knows or doesn't know your
column headings are column headings.
Do you mean it guesses correctly when you go to sort your data whether you
have headings or
Well, I see it does know so never mind.
On Monday, March 26, 2012 8:21:06 PM UTC-7, tangledweb wrote:
If I reply to that address, how does it know which thread to attach to?
On Mon, Mar 26, 2012 at 8:10 PM, Domain Admin domainqu...@gmail.com
wrote:
Thanks again. Will try
Excel keeps wanting to override me and make row 1 be column headers but in
a particular case I need it to be just data. Any way to force this?
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
I determine it by sorting the column. If the first row is left out of the
sort then it is treating it as a header.
You say you can override excel on this. How is that done?
On Friday, March 23, 2012 12:41:57 AM UTC-7, Asa R. wrote:
Hi H.,
Not sure how you are determining that Excel
I determine it by sorting the column. If the first row is left out of the
sort then it is treating it as a header.
You say you can override excel on this. How is that done?
On Friday, March 23, 2012 12:41:57 AM UTC-7, Asa R. wrote:
Hi H.,
Not sure how you are determining that Excel knows
Asa,
I tried what you said but am doing something wrong. First when I used the
exact same string as both the Set variable and the Match variable it said
it needed an object.
It did not like identical names I guess?
Then I created different object names and that would compile but I have
tried
Asa,
I tried what you said but am doing something wrong. First when I used the
exact same string as both the Set variable and the Match variable it said
it needed an object.
It did not like identical names I guess?
Then I created different object names and that would compile but I have
tried
First before I forget, thanks again for the help.
Maybe I need to go find a more comprehensive book. The one I have does not
mention the Set command, does not list Range as a data type, does not
mention tables (which may be useful but that is too ambitious at this
point).
From the other
Excel does a very good job of knowing row 1 is column names even if the
data type is the same for the entire column.
But it is not always correct. If I insert columns of numbers then insert
a new row1 and put in text headers it considers them
column names even if the entire column is set to
I am trying to understand how to name a column of data and be able to
reference the data by that name. Ideally I could set the name
programatically but if it needs to be done through the ribbon command
that is acceptable.
Ideally inserting a new column before the named column will not affect
that
32 matches
Mail list logo
