Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Vlookup Only Working Half Way Down Spreadsheet?


I have a spreadsheet with members details in and I've added a few columns showing:

Col Q: Paid 2008 (blank if No, 1 if Yes)
Col R: Show Paid Yes or No (shows a Yes or a No)
Col S: Date Joined (only entered if new and joined during 2008)
Col Z: Subs owing from 2008 (if existing members and owe last yr's subs)
Col AA: Subs to Pay in 2009 (a standard £35 or pro rata if joined during 2008)
Col AB: Pro Rata (if they joined other than at the beginning of 2008)
Col AC: EA Sub? (based on a yes/no column, to add £5 if yes)
Col AD: Total to Pay for 2009

So the formulae (or data entered) for the above columns are as follows:

Col Q: Paid 2008 - blank if no, 1 if Yes
Col R: Show Paid Yes or No - =IF(Q2=1,"Yes","No")
Col S: Date Joined - a date entered in format d/m/yy
Col Z: Subs owing from 2008 - =IF(R2="no", 35,0)....I want a default 35 in here
Col AA: Subs to Pay in 2009 - =IF(S2="",35,"Pro Rata")....says that if there is no date which indicates they are an existing member, they will pay the standard 35, otherwise they'll be paying a pro rata fee...................

Problem:
It all works fine until a certain row (27 actually) - then I get a VALUE! error which points to the Date Joined field. Now I've tested that value against the vlookup table and it returns the correct data, so why doesn't it do it in my spreadsheet????? I've tried changing the formats on the cells; clearing all data; entering a different date, but from that row in the spreadsheet down to the last row, it simply won't work! I've looked at each formula in each cell on the rows where it is working and the rows where it isn't and I can't see anything different.

What else can I look for? It is SO frustrating as it does what I need it to to do but only for a third of the spreadsheet!!!!


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Formulas Stop Working When Put The Rows Of Data To Test My Spreadsheet
I am inputting rows of data to test my spreadsheet and all of the sudden the formulas stop working??

Can someone take a peak at it and see if they can tell why its no longer working at I19?

View Replies!   View Related
Vlookup Not Working
I have a vlookup that returns an #N/A error due to the table array originally being formatted as text. The data is simply a two or three digit number.

I have tried everything I can think of to get the table array to equal the lookup value.

I formated cell to number. I tried tab delimated/finish. I tried typing a 1 in a different cell and doing a paste special then multiply. I tried copying to a different worksheet. I just cannot get it to work.


View Replies!   View Related
Get Vlookup In Vba Working
I have 3 sheets ("zip", "report", "ches") in a workbook

I want "ches" column A to be filled with data from "report" column D if there is a match of "zip" cell A12 from "report" column S

I keep getting the error
"unable to get the Vlookup property of the WorksheetFunction class"

Private Sub Worksheet_Change(ByVal Target As Range)

Dim myRange As Range
Dim myRange1 As Range

Set myRange = ActiveWorkbook.Worksheets("report").Range("A1:S65536")
Set myRange1 = ActiveWorkbook.Worksheets("ches").Range("a65536").End(xlUp).Offset(1, 0)

myRange1.Value = Application.WorksheetFunction.VLookup(ActiveWorkbook.Worksheets("zip").Range("a12"), myRange, 4)
End Sub

View Replies!   View Related
Vlookup Not Working Properly
I have problem with vlookup. I am attaching my file.

View Replies!   View Related
Multiple Checks For IF - VLOOKUP Not Working
embedding the following
(VLOOKUP(A2,[svdlsa08_2007mast.xls]Sheet1!$A$2:$U$3869,1,FALSE)

in the following statement:

=IF(((VLOOKUP(A2,[svdlsa08_2007mast.xls]Sheet1!$A$2:$U$3869,1,FALSE))-A2=0),(VLOOKUP(C2,[svdlsa08_2007mast.xls]Sheet1!$C$2:$U$3869,17,FALSE)),"No Match")

The IF statement is designed to check a different value in the source spreadsheet against one in the destination sheet which should always match for the desired values, but this doesn't seem to make any difference to what is being returned - I'm still getting the first match instead of the appropriate one.

Is there a better way to force the VLOOKUP to return the value from the correct match and not just the first one?

View Replies!   View Related
Vlookup Formula Is Working On Some Criteria But Not Others
The vlookup formula is only partly working on the attached sheet, but I cant find an explanation as to why it can look up some criteria but not others.

View Replies!   View Related
Aggregate Function On Vlookup Array Not Working
I am trying to create a single cell formula that returns the min value of an array returned from a vlookup function. This is part of a more complex solution that I am trying to implement, but I think I have narrowed my problem down to this issue, so I have created a very simple example to demonstrate.

Cells A1 to B5 contain a lookup table:

table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}

LetterNumber D4 C3 B2 A1

Cells A7 to C8 contain the input values:

table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}..................


View Replies!   View Related
Vlookup Formula Not Working With Data On Separate Sheet
I have a sheet set up with names. I have 2 other sheets with spouses and
children that belong to the first sheet. I want to insert a formula that
will look up the correct spouse (based on a member number) and put in it the
column. Same with the children. I tried the vlookup function, but it did
not return the correct result.

View Replies!   View Related
Multiplying Cost By Variable Factors, Vlookup Not Working
I have an Excel 2003 situation I cannot resolve. In one workbook, I have a table of multiplication factors based on a numerical general ledger code. On another sheet, I have a data extract including that code and a cost. In the latter sheet, I need to multiply cost by the appropriate factor based on the GL code - IF Code=X, then cost*factor.

Should be simple, but I have too many codes for a nested IF statement. I also tried a VLOOKUP, but since the codes are numerical, Excel interprets them to be in the thousands, while my factors are 1.xxxxxxx, and since the data being looked up thereby appears smaller than the keys, VLOOKUP will only return #N/A or ?NAME, depending on whether I try to nest it in an IF or not. I also have several thousand records per month to which this needs to be applied, so going manual is not an option.

The calculating is done in column E, the original cost is in column AB, the key (GL code) is in column R, and the GL code range with factors is on the !Factors sheet (column A=Code, B=Description, C=factor).

*I'm running Excel 2003 on WinXP Pro

View Replies!   View Related
Split A Cell In Half
Is there any way I can split a cell in half, so I can put numbers in the left part of the cell, and the right part?

If so, I would I refer to those numbers in my macro?

View Replies!   View Related
1/2 As In A Half But Its Coming Up With The Date
When I enter 1/2 I want it to stay as a half but when I press enter it automatically changes to the date. How can I stop this?

View Replies!   View Related
Pause For 0.5 Seconds (half A Second)
I need to pause for 0.5 seconds (half a second). How can I do that. applicatiom.Wait can only be used for whole seconds and a FOR ... NEXT loop is CPU dependant.

View Replies!   View Related
Half Of Chart Column Is Not Visible
I have created a combination chart comprising a column and a line. The columns to the extreme right and left are half visible (I can only see half of the column).

Look at my two attachments to see what i mean.
Attachments:
Excel File: http://www.MegaShare.com/235337
Screenshot:
OR
http://img530.imageshack.us/my.php?i...icture1qi7.png

Note: I have cross-posted this thread in excelforum.com: http://www.excelforum.com/showthread.php?t=608124

View Replies!   View Related
Formula- Working On A Spreadsheet To Control The 'booking Diary'
I've been working on a spreadsheet to control the 'booking diary' at work and linking it with the movements in and out of our 'chambers'

If you look at Column L & M, they are the volumes and column N is where the 'pallet' is coming / going to .

If you look at line 149 and below I've tried to translate these 'volumes' into movements by time but as you can see it is not to totalled up correctly during certain times.

For example line 158 should total 40 and line 187 should total 80.

Can anyone work it out for me as this happens on numerous lines

View Replies!   View Related
Looped Error Check Not Working: Error 1004 Is Generated When A Match Cannot Be Found In The Spreadsheet
the if stattement works perfectly and does exactly what i want except when it comes to the else part. if there is no error the statements are run perfectly but if there is an error (in this case the error is generated when a match cannot be found in the spreadsheet) the else statement doesnt kick in and post the msgbox.
the code just crashes. and returns an error 1004 on the line i have highlighted in yellow

res = WorksheetFunction.Match(invvar, Columns(1), 0)
If Not IsError(res) Then

Me.txtClientID.Value = ws13. Cells(res, 7)
Me.txtNumber.Value = ws13.Cells(res, 7)
Me.txtDate.Value = ws13.Cells(res, 8)

'save client id as a variable
'Print to invoice------------------------------------------------------------------.....................

View Replies!   View Related
Macro To Format Half Of The Cell With A Different Color
I have a list of records that will eventually be used to create a pivot table. Sometimes an account number will be listed twice but instead of adding to the previous info, it needs to start a new record. I decided in these instances to mark the account number with a character (+). Even though the + will designate a separate record, I'd like it to be invisible.

Is there a way to automatically turn the font color white for only the +? Since I've automated the rest of the process using a macro, a VBA solution is fine.

View Replies!   View Related
Vlookup Type Macro Autorun Upon Any Changes Made To The Spreadsheet
I have a warehouse of skids with multiple boxes of barcoded documents on each skid. The tab "Warehouse Inventory" has the range of barcodes in each box on a given skid (boxes are numbered, skids are lettered). Under the Search tab, I will be copying a list of barcodes into Column A, from another spreadsheet, and would like a macro, to autorun upon any changes made to the spreadsheet, that will do a VLOOKUP type search and reply back in Column B and C the skid letter and box number respectively

View Replies!   View Related
Calculating Full-width Half-max (fwhm)
calculate the full-width half-max of a peak in data? My chart (gray value vs. pixels) essentially looks like a letter M. What I've tried is finding the max of each peak, dividing that by two, and then using vlookup to find the corresponding pixel values on each side of the peak. But, since vlookup does not work for descending values, I cannot find the half-max value on the right side of each peak.

View Replies!   View Related
IF/VLOOKUP (set Up A Spreadsheet Which Automatically Calculates The Start And End Dates Of Project Tasks)
I am trying to set up a spreadsheet which automatically calculates the start and end dates of project tasks, by looking at the order in which tasks need to be completed. I have attached a spreadsheet to show what I am trying to do.

View Replies!   View Related
Determine Half-Way Point Of Bar Series On Bar Chart/Graph
i have created a xlColumnStacked chart using VBA in excel 2000. i would like to place a line in the center of one of the Points(). How can i locate a specific point, for example Points(1), so what i can then "draw" a line in the center

View Replies!   View Related
Calculating Time And A Half And Double Time (After 40 Hours)
I'm battling to come up with the formula to calculate time and a half and double time. My boss wants me to show the overtime worked AFTER 40 hours has been worked. I have attached a copy of my spreadsheet.

View Replies!   View Related
Macros That Were Working In Excel 2003 Are Not Working In 2007
I have a workbook in excel 2003 which I had been running the following macros (listed below). We recently upgraded to Excel 07, and neither are working. When I try to run them, the "debug" option highlights the following line in the sort macro "Range("A2:z" & lastcell).Sort key1:=.Columns(1)". This is driving me crazy, as the macros worked perfectly under the older version of Microsoft. Is there an issue with crossfunctionality between '03 and '07'.

Private Sub Worksheet_change(ByVal target As Excel.Range)
If target.Column = 1 Then
ThisRow = target.Row
startRow = 1
i = 1
Set ws = ActiveSheet
maxRow = Cells.SpecialCells(xlLastCell).Row
maxCol = Cells.SpecialCells(xlLastCell).Column
ActiveSheet.UsedRange.Interior.ColorIndex = xlNone
Do While i

View Replies!   View Related
Spreadsheet That I Have A Lot Of Macros That Are Attached To A Customized Toolbar Saved In The Same Spreadsheet
I have a spreadsheet that I have a lot of macros that are attached to a customized toolbar saved in the same spreadsheet. I saved this is a read-only file. When I open as read-only and run my macros (testing), I save it as another file. When I then open the "template" to do the same thing, the toolbar/buttons now reference the file I previously saved as something else. Help please? Is there a macro that would delete all macros before saving the file as something else?

View Replies!   View Related
Merge Files? (add Data From One Spreadsheet To The Appropriate Places On Another Spreadsheet)
Often I need to add data from one spreadsheet to the appropriate places on another spreadsheet. For example:

Sheet A has 10,000 records with these fields: id#, name, address, place of employment.

Sheet B has 5,000 records these fields: id#, GPA, college major, type of degree.

Some of the records in B contain information for the same id#'s as sheet A. I want to add this information together so that a Sheet C will have these fields: id#, name, address, place of employment, GPA, college major, type of degree.

View Replies!   View Related
Multi-Spreadsheet Formula Down To Populate The Other Cells In The Total Spreadsheet
I have attached a document paralleling a document I am working on. The dollar amount in each spreadsheet represent sales. I have entered in values into the candy, soda, and chips spreadsheet. I have also linked values for candy into the total spreadsheet. My question is can I somehow type something or drag the formula down to populate the other cells in the total spreadsheet?

The idea I am thinking but which I don't know how to implement is to list all the items (as in column G) and list all of the relevant cells (e.g. B1 in the Candy spreadsheet) as in columns H and I (Note that all items will have the same cells but the cells will have different values...e.g. all three items have a cell B1 and B2 in their spreadsheet but these cells contain different values). I then try and fail to create a formula in cell B3 of the Total spreadsheet. I am trying to create a formula of the following nature:

='(Spreadsheet Name From Column G)'!(Cell Name From Columns H and I)

The Second half of the formula doesn't really concern me (i.e. the cell name from column H and I). However I am perplexed as to how to achieve the goal in the first parentheses above.

View Replies!   View Related
Copy Certain Cells From 1 Spreadsheet To Other Spreadsheet Depending On Condition
I have noticed that the basic problem I have is a common one on this forum with different varibles for different people. I have attached a dummy copy of the spreadsheet that I am using.

I need to copy cell information for one spreadsheet to one of 2 other spreadsheets depending on a dropbox condition. The master spreadsheet is the Issues spreadsheet, and depending on whether the user chooses Transferred Complaints or Transferred Offences (in Column K) I need to transfer certain cells to the Complaints or Offences spreadsheets.

The information I need to transfer from Issues is: .....

View Replies!   View Related
Spreadsheet To Note Book And Back To Spreadsheet
It also renames the CommanBarPopop with the new filename.This allows the user to open both Projectworkbooks/files (If required) and load each CommandBarPopup for different filenames .Therefor opening the Userforms and worksheets for the CommandBarPopup clicked ...

View Replies!   View Related
Importing Data From Spreadsheet To Spreadsheet
I need to write a macro that will import data contained in another spreadsheet, but am unsure how to do this. I have several (about 15) spreadsheets that contain data. I need to import key bits of this data into one central spreadsheet that will be used for reporting purposes. I only need 2 cells worth (values) from each source spreadsheet, to be pasted into the destination spreadsheet, into designated cells.

The source spreadsheets are usually closed down and kept on a file server, which my PC has access to. Ideally I want to activate this macro with a control button - i.e. I press the button once and the macro goes off and collects/updates each field with the latest data stored in each of the source spreadsheets.

View Replies!   View Related
VLOOKUP With INDIRECT (become Dynamic As The Table Array Part Of The Vlookup Will Change)
I have a Vlookup which I want to modify so that it can become dynamic as the table array part of the vlookup will change.

So the basic vlookup is as follows:
=VLOOKUP($R$3,ATTRIBUTION_FACTSET!$M$60:$P$73,2,0)
but the data I am looking for wont always be in the range M60:P73.

So I tried to make it dynamic by doing the following:
=VLOOKUP($R$3,INDIRECT("ATTRIBUTION_FACTSET"&"!M"&U1&":P"&V1),2,FALSE)
The idea being that U1 and V1 would be numbers that can change so in this case U1 would equal 60 and V1 would equal 73

This vlookup is giving me #N/A and no matter how I modify it I cannot get it to work.

View Replies!   View Related
Working Day Function: (Day + Next 1st Working Day)
I was looking for a final result as follows

21-Aug-09 + 1 = 24-Aug-09 (Day + next 1st working day)

21-Aug-09 + 3 = 26-Aug-09 (Day + next 3rd working day)

View Replies!   View Related
Using Vlookup & Indirect To Ref List And Vlookup Files
I have a spreadsheet (Need Data.xls) that needs to be filled out with a couple columns of data.

This data lays within 338 spreadsheets which have many items and may only have 2, or 3, or 50 that belong on my Need Data.xls spreadsheet.

I have a tab in Need Data.xls named "DIR" which has a list of 336 excel files that need to vlookup'd into.(not a separate file) They're all setup with this format:

View Replies!   View Related
Hyperlinks And VLookup: VLookup To Find EMail And Web Addresses
I have a sheet using VLookup to find EMail and Web addresses. I can get the address to show up but not as an active URL address. Is it possible to have the address "active" so I can click on it and activate the EMail or Web Site?

View Replies!   View Related
Vlookup Across Sheets, Nested Vlookup Possibly?
I’m trying to develop a workbook which holds monthly data on loan information. It tracks the interest and balance on the loan. I want the first page to have a table displaying the interest payments for every individual tab. When I was brainstorming the idea, I was considering a sort of Vlookup function to find the tab the account is on and then a further function, possibly another vlookup which connects the month to that month’s interest payment. Can anyone help me figure this out?

The attached spreadsheet is obviously simplified, there are well over 30 tabs. But I would like it to, ideally, search the account number column, search the workbook for that account number, and then when on that page use the month at the top of the first page and retrieve the interest payment and put it back in the cell. It’d also be great if the formula can be transferred between workbooks. I’m not sure if that makes sense; basically if I were to copy that worksheet into the next months book, I would like that the formula read those tabs instead of becoming obsolete due to references from the first workbook.

View Replies!   View Related
Double VLookup (vlookup The Same Data From 2 Different Sheets)
I'm currently trying to vlookup the same data from 2 different sheets. Here is the code i've tried.

View Replies!   View Related
Vlookup Looping (for Each...next?). Vlookup Loop Technique
I have data in a pivottable which I want to compare with another table. The lastcolumn+1 of the pivottable needs to get data from another table. I have this for an example:

View Replies!   View Related
Open Second Spreadsheet Minimized On Open Of Spreadsheet + More
I have a spreadsheet that on open needs to open a 2nd spreadsheet minimised and delete 2 named sheets in the 2nd spreadsheet.

On close of the first spreadsheet it should then copy 2 sheets with the same name from itself into the 2nd spreadsheet.

This is to start a spreadsheet that will track project risks and issues that I will post further details for as other functions are required.

View Replies!   View Related
Vlookup Error Msg "unable To Get The VLookup Property Of The WorksheetFunction Class"
I am receiving a run-time error with following code. The error message is "unable to get the VLookup property of the WorksheetFunction class". I only receive the message when the lookup value is not found in the table.

I thought adding the "False" command at the end would return an "N/A" but it didn't. Is there anything I can add to avoid this error?

View Replies!   View Related
SUMPRODUCT Not Working For Me
what I want is quite simple actually. Worksheet 2 contains two columns where I want to search for certain text, when it finds the text in both columns (B & D) I want it to sum up the values in the same row on column F.

If I understood correctly there should be 2 ways to do this, using the SUMPRODUCT formula: ....

View Replies!   View Related
Working With Arrays
Below is my attempt to understand working with arrays of values.

Test() works fine. Yay! But it is "too easy" just plugging in a hard value for the range address...I don't always have that luxury. Normally I work with ranges that I've determined at runtime. I'd like to assign a range of values to an array but my attempt below -- test2() -- fails. I am not even sure if my effort is a good approach or not, but I know it doesn't work!

Basically, I am looking for how to assign the range of values to an array when I am determining the range in code -- as in:

After


Set Range = ~~

or,


Range(Cells(1,1),Cells(x,y)) ~~................


View Replies!   View Related
Trim Not Working
[data] ...

I am having problems removing "2009-642" from the above text string(s) (doesn't matter which)

This is just a sample line and it is not always in the same place so I am afraid a simple mid function from a set starting point will not suffice, the number is also dynamic in size, location and leading digits.

As a result I have created a formula to get rid of the "1 XS0444499197" part of the formula leaving me with " 2009-642 "

Now unfortunately I need to get rid of the spaces (or what look like spaces) just leaving me with the number but infuriatingly I can not get the trim function to work, so I can only guess that it is not in fact reading these spaces as spaces, and I'm at a bit of a loss how to proceed.

View Replies!   View Related
CONCATENATE Not Working
Create a column of concatenated values to serve as a "primary key" for a compare and merge tool (Synkronizer). For some reason, the CONCATENATE function isn't being recognized.

If I enter
=CONCATENATE(A2,B2)
instead of showing the strings located in A2 and B2 it displays
=CONCATENATE(A2,B2)
in the cell.

I tried creating a new spreadsheet and it works just fine. Does anyone have an idea of what might be happening? I have compared all of the options between the two spreadsheets and don't see any difference in them.

View Replies!   View Related
Hyperlinks Not Working
The following is a simplified example of my problem: I have a list of product item numbers in column A. Next to each item number in column B, is a hyperlink to a PDF file relevant to each item. Elsewhere in the sheet, is a drop down box containing the item numbers. Next to the drop down box is a HYPERLINK(VLOOKUP) that fetches the relevant hyperlink depending upon the selected item in the drop down box. Problem is, when I select the ‘lookup’ link, I get an error message ‘cannot open the specified file’ (the original Hyperlink works fine). Does anyone have a solution to this problem (preferably without resorting to Visual Basic?

View Replies!   View Related
Sub Worksheet_SelectionChange Not Working
I have popped the code below in the worksheet and it will not work on my machine (Vista + Office 2003). However, it works fine on my colleagues machine (XP + 2003).

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column < 4 Then GoTo usevalue
On Error Resume Next 'MUST reenable events...
Application.EnableEvents = False
ActiveCell.Offset(1, 1 - Target.Column).Select
Application.EnableEvents = True
usevalue:
ActiveCell.Copy 'Put value into clipboard (marching ants)
ActiveCell.Interior.ColorIndex = 36
End Sub

I have tried different code from different web sources on different fresh files. This includes the Worksheet_Activate() function.

My macro security setting are low.


View Replies!   View Related
Working With Dimensions
Is there a way in excel to say if i select Item1 and it is 100mm x 30mm x 100mm, excel will say this will fit into a compartment called A1 and may also fit into a compartment called B6.

I have a list of all the compartments and what the internal dimensions are. So is it just a matter of saying if these dimensions are within those of the compartment then that item will fit in.

I have a list of some what 6000 Items that have dimensions. I may pick 200 or so of these items to fit into special compartments of a machine. Because of the varying sizes i need to know what compartment each item will fit in so i can build a machine big enough and get the right size compartments.


View Replies!   View Related
Adding HH:MM:SS Not Working
I have a column with hours in the following format HH:MM:SS, that looks like this:

12:16:00
1:35:00
1:35:00
12:47:00
12:46:00
12:51:00
4:33:00
4:05:00
12:54:00
3:19:00
3:19:00


I am trying to add the sum total of all hours, but its not working. I have my column formatted as time -> 37:30:55

View Replies!   View Related
COUNTIF Not Working
I am using the following formula to count the total number of contract types if 'ITD $K' equals '0' zero. But it returns 0 as output.

=SUMPRODUCT('PROCUREMENT CONTRACTS'!$E$5:$E$225="GROSS")*('PROCUREMENT CONTRACTS'!$J$5:$J$225=0)

View Replies!   View Related
Working With Shapes
Where do I find a tutorial or examples to show me how to create bars for gantt chart in excel, based on date values?


View Replies!   View Related
Sendkeys Not Working
I'm trying to access one of my custom menus through a macro.

The keyboard commands are

alt, n, f

and

alt, n, g

I have these lines of
Range("A31").Select

SendKeys "%nf", True
SendKeys "%ng", True

All this seems to do is put the letters f and g in cell A31!

View Replies!   View Related
Working With Percentages
I have a column of data with students marks ranging from zero to 78(S17:S74). I need to work out the mean score of the bottom 20% of all the scores achieved - Is this possible. I'm no expert so please keep it as simple as possible! I'm working with Windows XP and Excel 2002.

View Replies!   View Related
Not Sure Why CRLF Not Working
This should simply insert a linebreak correct? Cannot figure out why the following is not working :

UpdateFX = MsgBox("Update the current FX rates" & @CRLF & _
"[x-rates.com 120 day history]", 65, "FX Rate Update")

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved