-
If you would like to post, please check out the MrExcel Message Board FAQ and register here.
If you forgot your password, you can reset your password.
erratic
-
T
Blank Workbook
Hope somebody has a solution... On openining any excel 2007 file (Win 7), excel opens the required file AND an additional blank workbook. This is happening only lately. Could an Offce/Windows update be the culprit? This is annoyng since I am working with a VB app that "reads" an open excel...- Tagliavini
- Thread
- blank workworkbook erratic excel
- Replies: 2
- Forum: Excel Questions
-
Date Format Erratic on Transfer From Array To Range
Hi. I've run into another problem! Baffling one this time!! I have an Array. I think it is an Array contained within a Variant Variable, rather than an Array of Variant DataType. It has 2 Dimensions. I want to output / paste the entire contents onto a Worksheet Range. The Range in question...- Default300
- Thread
- array array range mapping date format erratic string
- Replies: 11
- Forum: Excel Questions
-
D
Inexact VLookup producing erratic results
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p><o:p> </o:p>Could someone help me please this is driving me crazy! I am trying to use VLookup to separate out the different elements in a single cell. Items like the following...- DavidSCowan
- Thread
- erratic inexact vlookup
- Replies: 6
- Forum: Excel Questions
Watch MrExcel Video
This Week's Hot Topics
-
Slightly complicated Unique list
- Started by Beau the dog
- Replies: 28
Good afternoon I have a table of data, over 25000 rows long. I need to extract a unique list of vehicle registrations per contract. the column... -
VBA Destination range is not large enough..
- Started by afc171
- Replies: 27
Hi all, I am coping a selection of data to another sheet but keep getting message that the destination range is not large enough to accommodate... -
Why is this a runtime 91 error?
- Started by vbaNumpty
- Replies: 24
I am following a tutorial that demonstrates how to use advancedfilter and find functions in VBA code to populate a list box and allow for editing... -
Sales for multiple products in 1 Cell (to account for table order and #N/A)
- Started by bilal_aoun
- Replies: 23
Would you please help me find the sale in a single cell? Sales per day in cells B2:H9 Product type A5:A9 Product Price B16:C21 If we are to... -
Vba : Excel File Can't Save Picture Within The File It Self
- Started by muhammad susanto
- Replies: 23
hi all. i have macro code to insert picture from a folder. The code work properly. i have problem, after running code the pict is displayed but... -
Next without For, End If without Block If
- Started by Teleporpoise
- Replies: 22
Hi All, I've moved around my "if" and "end if", as well as the "for" and "next" statements in my code, but I continue to get one of those two...
