Hi,
I was wondering if I could get some help with an automated query
macro. The powerhouse of the program can be seen below:
For i_iterator = 1 To UBound(Times)
current_time = Times(i_iterator)
For site_iterator = 1 To UBound(Arr)
current_site = Arr(site_iterator)
Hi,
>From your mail box, send message with attachments to
excel-macros@googlegroups.com
This way you can send your files.
Regarding using only one macro:
Turn the *Sub macro1 ... END Sub*
in your macros to *Function macro1 END Function*
Write a separate macro as
*Sub callingall3*
*'call al
Hi!
I need to create a function to define a color of a cell depending on
the value of other.
PRobably this can be achieved using Conditional Formatting, but
actually I need to create a function for example
=cellcolor(Red,referenced cell)
Anyone can help me with this function?
Thanks!
Zek
--
I have a UserForm with a multi-selection ListBox (ListBox1) that is
populated with all the worksheet names. Based on the user's selection
(s), I am trying to export (copy/paste values & formats) for only
those selected worksheets when he/she clicks a CommandButton
(cbRunExport). I keep encounter
Can you define the variables as "default: variant" in the function,
then explicitly convert them?
as:
week_stock(tCini,tCfin,tStock,rRow,tPrev)
dim cini as integer
dim cfin as integer
dim stock as double
dim RowNum as integer '"row" has special meaning, I would not suggest defining
it as a varia
Hi
U can use below mentioned formula
TEXT(A1, "DD/mm/ H:MM:SS AM/PM ")& B1
Regards
Krupesh
On Tue, May 12, 2009 at 1:27 PM, wrote:
>
> Hello,
>
> I have a problem in displaying AM or PM, when i try to concatenate to
> cells. Below is the reference -
>
> Column A Column B
Pls,
Can you send your file, so I can debug it?
Regards
2009/5/14 Pedro75
>
> Hi.
> I have written a very simple function in VBA with 5 arguments. To
> support my query here's an example of the function definition:
> Public Function Week_Stock(cini As Integer, cfin As Integer, Stock As
> Double
Hi,
Excel should, in Theory, make this conversion. I have tow versions of Excel
(portuguese and english) and functions written in one language are
automatically changed when I open the file with the other version.
I think that you should have found a bug, have you searched on microsoft
database?
I have a spreadsheet that I have several references to the formula
'Networkdays'. The spreadsheet works great using the English
version
of Excel however, I have collegues that use a French copy of Excel
and
the spreadsheet does not function using that version of Excel.
In order to get the sprea
I think Jitendra & DHiraj have given the right solution
On 5/14/09, Jitendra mhashelkar wrote:
>
> Hi,
>
> u can giv Single Inverted coma ' before the no.
>
> e.g: '11E11
>
> try this & let me know if it works
>
> Thanks
>
> Jitu
>
>
> On Thu, May 14, 2009 at 10:48 AM, dhiraj shrestha <
> shres
Networkdays formula in French version of Excel options
I have a spreadsheet that I have several references to the formula
'Networkdays'. The spreadsheet works great using the English
version
of Excel however, I have collegues that use a French copy of Excel
and
the spreadsheet does not function
Hi.
I have written a very simple function in VBA with 5 arguments. To
support my query here's an example of the function definition:
Public Function Week_Stock(cini As Integer, cfin As Integer, Stock As
Double, row As Integer, prev As Integer). Each of these arguments are
linked to an excel cell.
=COUNTIF(C8,C8:C66)
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2
I have a spreadsheet that I have several references to the formula
'Networkdays'. The spreadsheet works great using the English
version
of Excel however, I have collegues that use a French copy of Excel
and
the spreadsheet does not function using that version of Excel.
In order to get the sprea
Hi Luca,
You can use the instr function.
e.g.: instr(string, searchstring) will give you the starting position of the
searchstring.
Len(searchstring) will give you the length of the portion to
highlight.
Regards,
Andy
On Thu, May 14, 2009 at 1:05 PM, JazzyXXL wrote:
>
> Hi Fabio,
> th
Hi,
u can giv Single Inverted coma ' before the no.
e.g: '11E11
try this & let me know if it works
Thanks
Jitu
On Thu, May 14, 2009 at 10:48 AM, dhiraj shrestha wrote:
> Write as *'11E17 **
>
> *
> On Thu, May 14, 2009 at 10:39 AM, ritesh paul wrote:
>
>> I think, u need to format the cell
Hi Fabio,
the problem is, that I do not know the exact position of the word in
the cell text.
I think the code should be structured like this:
1. search for WORD in cells of column 2
--> text found in cell(x,y)
2. find position of WORD in cell text
--> Start = 0
--> Start=instr(Start+1,cell(x
Write as *'11E17 **
*
On Thu, May 14, 2009 at 10:39 AM, ritesh paul wrote:
> I think, u need to format the cell in Number Format. Pls make decimal place
> as 0. U should
> get the result.
>
> Paul
>
> On Wed, May 13, 2009 at 7:26 PM, larry wrote:
>
>>
>> I am talking about the format cells comm
Dear Harmeet..!!
Now you are reached to the level.. "where people are "Right" in -
default.."..!!
Thanks.!!
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Thu, May 14, 2009 at 12:48 AM, Harmeet Singh wrote:
19 matches
Mail list logo
