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 repae
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 m
a little addition to Dilip's solution
see the attached file
On Thu, Feb 19, 2009 at 1:39 PM, Dilip Pandey wrote:
> Hi Prabhat,
>
> One dirty way may be:-
>
> Column A Column B Column C Column D 1 a =IF(A2=1,B2,"")
> =C2&C3&C4&C5&C6&C7 2 b =IF(A3=1,B3,"") 1 c =IF(A4=1,B4,"") 1 d
> =IF(A5=1
solution is a mix of both
Function GetAddress(HyperlinkCell As Range)
GetAddress = Replace (HyperlinkCell.Hyperlinks(1).Address, "mailto:";,
"")
End Function
To use this User Defined Function push Alt+F11 and go Insert>Module and
paste in the code. Push Alt+Q and save. The Function will
I can help you mate but where is the file
On Sat, Feb 21, 2009 at 2:45 PM, girish gv 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 need to register if
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 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 wrote:
>
>>
>> Hello everyone,
>>
>> My name is tamisha
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 &
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
Surely, but it would be easier if you can shre the excel file
On Sat, Feb 21, 2009 at 5:36 AM, LEX 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 some formulas that chan
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
Hindus
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
--~--~-~--~~~---~--
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 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 graph that au
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, k
--
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 Train
14 matches
Mail list logo