--
Hi LavPrasad,
Here is the solution to your query:
http://www.excelitems.com/2009/02/count-5-consecutive-zeroes.html
Regards
Ashish Jain
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft Office Specialist
Technical
if u can send that excel sheet i wil be able to assist u clearly
On Fri, Feb 6, 2009 at 7:40 AM, Tamisha vverd...@gmail.com wrote:
Hello everyone,
My name is tamisha and I recently joined this group to learn as much
as I can about MS excel and VBA. It is a pleasure.
I have created a pie
if u can download full version of VBA KEY Software then u can crack within a
secs. it is very easy to crack just type VBA Key in google u will
get the software ... but u need to register if any one have that pls
forwarrd to me also its giritri...@gmail.com
On Sun, Feb 8, 2009 at 9:37 PM,
is there any way to have a cell in excel update itself every week to
show the first day of the week?
say the week starts on a monday, the cell displays 23/02/09, retains
this value thoughout the week and displays 02/03/09 the following
monday
thanks
Dear Ashish,
Thanks for the reply. When I go to below mentioned site. There is macro
program. I had gone by step by step. but I am not getting the answer. There
is an #Name error has occured. Please help me attached the same file.
Thanks Regards,
Lavprasad Kori
MIS Executive - Water
Surely, but it would be easier if you can shre the excel file
On Sat, Feb 21, 2009 at 5:36 AM, LEX i...@grantsinternational.com wrote:
In excel 2003 I have inserted a web query (data-- import external
data-- new webquery) and have it updating every minute for some stock
quotes. I then have
Hi,
Below is the formula-
=IF(TEXT(TODAY(),ddd)=Sun,TODAY()-6,IF(TEXT(TODAY(),ddd)=Tue,TODAY()-1,IF(TEXT(TODAY(),ddd)=Wed,TODAY()-2,IF(TEXT(TODAY(),ddd)=Thu,TODAY()-3,IF(TEXT(TODAY(),ddd)=Fri,TODAY()-4,IF(TEXT(TODAY(),ddd)=Sat,TODAY()-5,TODAY()))
do let me know the feedback
On Sat, Feb
try this
Sub ggg()
Dim MyColumn As String
Dim MyRange As Range, MyRange1 As Range
MyColumn = A
myvalue = Main
lastrow = Cells(Rows.Count, MyColumn).End(xlUp).Row
Set MyRange = Range(MyColumn 1: MyColumn lastrow)
Range(MyColumn 1).Select
For i = 1 To lastrow
If Range(MyColumn i).Value =
I can help you mate but where is the file
On Sat, Feb 21, 2009 at 2:45 PM, girish gv giritri...@gmail.com wrote:
if u can download full version of VBA KEY Software then u can crack within
a secs. it is very easy to crack just type VBA Key in google u will
get the software ... but u
Hi,
If you can provide a dummy excel sheet with data.
Would be easy to help
On Sat, Feb 21, 2009 at 2:48 PM, girish gv giritri...@gmail.com wrote:
if u can send that excel sheet i wil be able to assist u clearly
On Fri, Feb 6, 2009 at 7:40 AM, Tamisha vverd...@gmail.com wrote:
Hello
a little addition to Dilip's solution
see the attached file
On Thu, Feb 19, 2009 at 1:39 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Prabhat,
One dirty way may be:-
Column A Column B Column C Column D 1 a =IF(A2=1,B2,)
=C2C3C4C5C6C7 2 b =IF(A3=1,B3,) 1 c =IF(A4=1,B4,) 1 d
Hi Art,
Contract codes are always a pain. The following functions generate
the previous n codes:
Option Explicit
Private MonthCodes() As String
Public Function GetExpiredCodes(currentContract As String,
noOfPreviousContracts As Integer) As String()
Dim startMonthCode As String
Dim
i would like to create a loop (do while) in order to copy paste
different name from a list box and write it on a database on different
rows. (one name for one row) the key for each row is already linked to
the names .i am able to do it for the first name selected in the
listbox but i need to
13 matches
Mail list logo