Over 1 million tech questions and answers.

Solved: Excel Programming Code Produces Wrong Value

Q: Solved: Excel Programming Code Produces Wrong Value

I am writing a food costing program using excel. The program is designed to pull prices from various tabs(different suppliers) to a main Supplier Costing Page containing all the information on products for all suppliers. The code allows the user to enter in the name of the product, then uses the LOOKUP function to search for the product and returns the value in that row. The code I used to pull the information from the different suppliers works properly:

A19 value Steak Strip Loin C/C St. Silver FRSH

=LOOKUP(A19,Centennial!$A$6:Centennial!$A$100,Centennial!$R$6:Centennial!$R$100)

Centennial is the tab for that supplier. It pulls the correct value from the page 0.74, to cell R19
The problem I am having is that when I try to use this format of code on another tab it does not return the correct value:

=LOOKUP(A33,'Supplier Costing'!$A$6:'Supplier Costing'!$A$100,'Supplier Costing'!$R$6:'Supplier Costing'!$R$100)

The code should return the same value of the previous line of code as it is the same product:0.74 to cell R33 this time, however it returns the value of another product on the Supplier Costing tab. Is the LOOKUP function not searching the tab for the whole string? Any help or suggestions would be extremely helpfull. Thanks

RELEVANCY SCORE 200
Preferred Solution: Solved: Excel Programming Code Produces Wrong Value

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Excel Programming Code Produces Wrong Value

Read other 12 answers
RELEVANCY SCORE 74.8

when i try to make an vba code in excel vba extension at the moment i added
this line to the code of a button:

Range("A1").End(xlDown).Offset(1, 0).Select
it says there is an error but i did exactly what they said on this video
https://www.youtube.com/watch?v=CzP8nO9UVvY
its explained just after 25:12 minutes

A:excel vba programming code

I tried the code and it works without errors. Are you sure it's that line it complains about?

This shorter one works to: Range("A1").End(xlDown).Select

Read other 9 answers
RELEVANCY SCORE 60.4

I use Windows XP Home + IE 8 SP3 coupled with an HP DeskJet 600 printer which has worked satisfactorily up until recently. Now whenever I print off or even just File Preview a web page including the text of an email, all that comes off is what appears to be formatting code, could be HTML for all I know. If I copy and paste into MS Word, and then print, everything happens as normal, but that is just concealing the root problem. I cannot account for the change, possibly I have updated some security software that has affected the settings, so don't know where to start looking for a solution. Any magic suggestions gratefully received.
 

Read other answers
RELEVANCY SCORE 59.6

Internet searches come back with valid titles, but the wrong actual links. It happens in both IE and Safari. I ran a scan with AdAware, Spybot, and Symantec Antivirus with the latest definitions (1/8/09) and nothing was found. When doing a Google search for salmon for example, I notice at the bottom "footer" of the screen it says "Opening Page <hxxp://www.google.com/search?hl=en&rls=GWYA,GWYA:2005-32,GWYA:en&q=salmon&btnG=Search..>. Thanks for taking a look and helping!!DS (Ver_09-01-07.01) - NTFSx86Run by Owner at 14:03:57.54 on Sat 01/10/2009Internet Explorer: 6.0.2900.5512Microsoft Windows XP Professional 5.1.2600.3.1252.1.1033.18.502.104 [GMT -5:00]AV: Norton Internet Security *On-access scanning enabled* (Updated)AV: Symantec AntiVirus Corporate Edition *On-access scanning enabled* (Updated)FW: Norton Internet Security *enabled*============== Running Processes ===============C:\WINDOWS\system32\svchost -k DcomLaunchsvchost.exeC:\WINDOWS\System32\svchost.exe -k netsvcssvchost.exesvchost.exeC:\Program Files\Common Files\Symantec Shared\ccSetMgr.exeC:\Program Files\Common Files\Symantec Shared\ccEvtMgr.exeC:\Program Files\Lavasoft\Ad-Aware\aawservice.exeC:\WINDOWS\Explorer.EXEC:\WINDOWS\ehome\ehtray.exeC:\Program Files\Digital Media Reader\shwiconem.exeC:\WINDOWS\zHotkey.exeC:\Program Files\CyberLink\PowerDVD\PDVDServ.exeC:\WINDOWS\system32\igfxtray.exeC:\Program Files\Common Files\Symantec Shared\ccApp.exeC:\PROGRA~1\SYMANT~1\VPTray.exeC:\PROGRA~1\Sony\SO... Read more

A:Internet Search Produces Valid Titles but Wrong Links in IE & Safari

Hello. I am PropagandaPanda (Panda or PP for short), and I will be helping you.Disable Realtime ProtectionAntimalware programs can interfere with ComboFix and other tools we need to run. Please temporarily disable all realtime protections you have enabled. Refer to this page, if you are unsure how.To disable Norton Antivirus.Right click on thr Norton icon () beside your click and select Disable Auto-Protect.Select a disabled duration of 5 hours to ensure that it will not interfere with this fix.Click OK to apply the settings.When done properly, you should recieve a pop-up warning saying that protection was disabled. The Norton icon should now look like .To disable SpyBot's TeaTimer:You can find instructions with visuals here.Run Spybot-S&D in Advanced Mode. If it is not already set to do this Go to the Mode menu select Advanced Mode.On the left hand side, Click on Tools. Click on the Resident icon in the list.Uncheck Resident TeaTimer and OK any prompts.Download ResetTeaTimer.bat and run it to remove entries set by TeaTimer. If you are not using Internet Explorer, you may not be prompted to download the file when you click it. In that case, right click it and select "Save Target/Link as" and save the file onto your desktop.
The file should take only a second to finish. Delete this file after use.Restart your computer for the changes to take affect.Download and Run ComboFixIf you have already run ComboFix, delete your copy and download a new one. If the computer in questi... Read more

Read other 7 answers
RELEVANCY SCORE 59.2

Hello,

I have recently purchased a new pc.

Specs:

Gigabyte GA-A55M-S2H

AMD A4 3400

4GB RAM

Western Digital 500GB HDD

Samsung DVDWBD SH-B083L ATA

RADEON HD 4670

AWARD BIOS v6

I wanted to have a dual boot setup using Windows 7 Home Edition and Windows XP (neither are OEM) using 2 partitions on the HDD. I installed Windows 7 first on a 150GB partition without issue. I then attempted to install Windows XP. Windows loaded the files prior to install then I got a blue screen with a message that Windows had detected an issue and had stopped the installation to save my computer with the following error code:

0xF78D2524 0xC0000034 0x00000000 0x00000000

I spent some time researching online and every response suggested going into the BIOS and either disabling AHCI, change from RAID/Auto AHCI to Auto ATA or set IDE mode as default. I had a look through the BIOS and the closest thing I could find was

OnChip Sata Controller: Enabled
and
OnChip Sata Type: Native IDE

Can anyone help me obtain a dual boot system without this error message appearing?

Thanks,

Shantelle.

UPDATE: Someone suggested I needed to install XP first. I deleted both the 100MB system partition and Windows 7 itself, attempted to install XP but received the same error code.
Shantelle.

A:Dual Boot Produces Error Code 0x0000007B

First check for all the Win XP drivers for your hardware on the manufacturer's web site.
If your Win XP CD, does not support your Sata Controller, you will need to load drivers to uses at F6.
Load Sata Controller drivers with a floppy disk is the best way.
SATA Drivers - Load in Windows XP Setup on Dual Boot
OR
SATA Drivers - Slipstream into Windows XP CD



Dual Boot Installation with Windows 7 and XP

Read other 4 answers
RELEVANCY SCORE 57.6

Firstly I am a beginner of beginners but I try to learn as much as I can.
I have put the following protection code into an Excel 2003 workbook and everything runs ok. I then opened the workbook in Excel 2007, and saved it as a .xlsm file. When I try to open the .xlsm file in Excel 2007, I get a vba Runtime error 13, "Type mismatch", and the code sticks at the first line below("If Worksheets...). I have tried everything that my limited knowledge allows, searched the web for 2 days, and still have no answers.
Any help would be greatly appreciated.

Private Sub Workbook_Open()
If Worksheets(28).[A51] > "" And Worksheets(28).[A50] = Worksheets(28).[A51] = False Then
MsgBox "Sorry, this program is not registered for this computer, please e-mail .......... for more info."
Application.DisplayAlerts = False
Application.Quit
End If
End Sub
My system specs are shown below.

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i3 CPU M 380 @ 2.53GHz, Intel64 Family 6 Model 37 Stepping 5
Processor Count: 4
RAM: 2934 Mb
Graphics Card: Intel(R) HD Graphics, 1243 Mb
Hard Drives: C: Total - 290143 MB, Free - 172186 MB;
Motherboard: Dell Inc., 0WXY9J
Antivirus: avast! Antivirus, Updated and Enabled
 

A:Solved: Excel 2003 vba code not working in Excel 2007

Read other 16 answers
RELEVANCY SCORE 54.4

Code:
ActiveCell.Offset(1, 0).range(ActiveCell.Address(), range(ActiveCell.Address()).End(xlDown)).Select
It's suppose to select from the cursor down to the last piece of data in the column.

It works on Column A, but beyond that (B, C etc) it selects further to the right in another column.
 

A:Solved: Excel: What's wrong with this VBA?

Read other 15 answers
RELEVANCY SCORE 54

I was just wondering if anyone could help me with writing a macro in excel. I am fairly new to VBA. I am trying to set up a Macro that will chart data and display values above a target line green and values below the target line red. If anyone can help me with this that would be great!

Thanks,
Matt
 

A:VBA programming on excel

Hi cub18,

Welcome to the forums.

Plenty of people will help you on here, but you need to give a bit more information, and an attached spreadsheet is always a great benefit when attempting to solve issues like this.

It sounds like you just need to use conditional formatting, but again it depends on the details.
 

Read other 3 answers
RELEVANCY SCORE 54

I am trying to change the D53 cell reference in this statement to a variable defined as integer, without success. I would be willing to change the whole range definition to a variable if necessary. Any suggestions would be appreciated!!

ActiveChart.SetSourceData Source:=Sheets("WorkSheet").Range("A29:d53"), _
PlotBy:=xlColumns
 

A:Excel VB Programming

Welcome to the board, Bob W.

Where will the values come from?

x = Application.InputBox("How many rows?", "Size chart range")
y = Application.InputBox("How many columns?", "Size chart range", 4)
ActiveChart.SetSourceData Source:=Sheets("WorkSheet").Range("A29").Resize(x, y), _
PlotBy:=xlColumns

, perhaps.

HTH,
bomb
 

Read other 1 answers
RELEVANCY SCORE 54

Hi

Id like to set Toggle Button 1:

When Value to show Cell A1
Else, cell 1 to be hidden.

Advice please!

Thanks!

M
 

Read other answers
RELEVANCY SCORE 54

Say, for example, I have a list of interest rates and the more people I sign up to my program, the higher my interest rate is. The time money would be invest for, is on the left-hand side, and the amount of people signed up is on the top.The items listed down on the left-hand side are as follows:~ Weekly~ Fortnightly~ Monthly~ 2 Months~ 3 MonthsThe top of the cells are from 1 - 10.The interest increase both as they go down, and across to the right.My question about this, is if I were to have a different table, and in that table I have people who sign up people, and I have (I have cell referenced each part)A1 - NameA2 - People signed upA3 - Interest rateB1 - JohnB2 - 3B3 - (the interest rate)C1 - AimeeC2 - 7C3 - (the interest rate)I was to know that from the first table set up, how can I get Column 3 to represent the cell from the amount of people that have signed up. So, that in Column 3, the interest rate that is shown is from the first table, and gets the amount of interest from the people signed up.No, it's not just simple "cell referencing" because I want the interest rate to be based on both the, time period, and how many people signed up, and I want it to be automatic instead of me doing it manually.Is it possible?NOTE: Here is a perfect example of what I want to achieve, just some things change.

A:Excel Programming?

I'm not an Excel guru but I'm sure that you could make something work with either a combination of VLookup and HLookup or just Hlookup and an if statement.Here's a pretty good link on embedded vlookups. hlookups work the same way except it searches by the row rather than a column.http://pubs.logicalexpressions.com/Pub0009...icle.asp?ID=446

Read other 2 answers
RELEVANCY SCORE 54

I was asked to make a program using excel for the main purpose of managing shares, stocks, investments and others. That's why I am looking for good tutorials for excel programming, for this will be my first time doing something of the sort.
If any1 could give good recomendations and/or tips, it would be fantastic.
Thanks in advance guys. As usual, life savers ;)

Just noticed that Excel Programming is VB. So also comments on this area would be helpful.

A:Excel Programming

Are you asking how to set up a spreadsheet to "manage" investments, or perhaps about Macros to automate the process? I think it would help us if you could clarify what you expect the spreadsheet to do.
Thanks,
John

Read other 5 answers
RELEVANCY SCORE 54

I am developing a system using java and am in need of a java code that allows a person to enter a password only three times. please help.
 

Read other answers
RELEVANCY SCORE 53.2

Hiya

This is the sample code for Applied XML Programming for Microsoft® .NET, 0-7356-1801-1.

System Requirements

To run the sample applications, you'll need the Microsoft .NET Framework and Microsoft Visual Studio .NET. Most of the samples also require Microsoft SQL Server 2000. A few samples make use of Microsoft Access 2000 databases, and some require SOAP Toolkit 2.0 and SQLXML 3.0.

For more detailed information about the System Requirements, refer to the book's Introduction.

Operating System - Windows 98, NT4 & 2000, Windows Me, Win XP

http://www.microsoft.com/downloads/release.asp?ReleaseID=42809&area=search&ordinal=5

Regards

eddie
 

Read other answers
RELEVANCY SCORE 53.2

help. i've installed qb 2009 on my laptop. i already have the validation issued by the company. where can i input the code AFTER installation?
thanks. lee

A:quickbooks pro 2009 validation code [from programming]

Hi Lee,

Not sure if 'QB 2009' is 'QuickBooks 2009' but I'd contact the Software Manufacturer for technical assistance as this is the Windows XP forum, for Operating System issues.

http://www.quickbooksheaven.com/contactdetails.htm

Cheers.

Read other 1 answers
RELEVANCY SCORE 53.2

I have two spreadsheets; the first has two columns, UPC and ITEM; the second has many columns of which UPC is one. I need to create a lookup function or something that will insert the value of ITEM from the first spreadshet into a new column I will create in the second spreadsheet based on the UPC matching. I prefer to use Access for these situations but I don't want to do that with this data. Is this easy to do?
 

A:Excel LOOKUP Programming

Yes. Give me 5 minutes & I'll post a formula. Or does it have to be "programming"?
 

Read other 3 answers
RELEVANCY SCORE 53.2

Anybody know how to format a cell like this?

I would like my cell to total up a bunch of items, much like the Epsilon (at sum), but then I want the display font to be blue when it is positive, and then red when it is negative.

Thank you.

------------------
"There are no stupid questions, just stupid people." -- Mr. Garrison on South Park
 

A:Excel Programming... or formatting

Highlight the cell, rows or columns you want formatted. On the Menu-Format>Conditional Formatting. Using the
Cell is: Greater than: 0 and
Cell is: Less than: 0
and specifing the patterns or font you want for each particular scenario should get you what you want.

The above uses two Conditional Formats you may be able to get your conditions set up using only one box. It also leaves 0 without a format so you may want it to be inclusive on the negative or positive result.

 

Read other 3 answers
RELEVANCY SCORE 53.2

Hi Guys,

Let me start off by stating that I'm still trying to learn all the juicy functions you can do with Excel, and I've just gotten myself a little project where I think I can learn but I need some kind of help from you guys.

Basically what I'm trying to do is somehow automate a creation of a report via excel, first method I thought of was to use macros, but since the data that'll be included in the report will be on a different cell each time, macro might not work as I imagined it to be, then I thought of the IF function, I have not yet tried doing that, but would that work? Can you please share your thoughts? Ask me any additional info and i'll try to explain it as simple as I can.

Cheers.

A:[HELP] Programming in Excel 2013

Your description is entirely too vague in order for anyone to offer any kind of help. Can you be more specific as to what kind of a report you want to generate and what data you will be using?

Perhaps you could post a sample of the worksheet with the data and a sample of what you want the report to look like.

Read other 2 answers
RELEVANCY SCORE 53.2

I am writing a food costing program in excel to calculate a number of costs, conversions etc. in Microsoft Excel. I have my code working to what I would like it to do but I have hit one snag. I want to be able to copy and paste the code throughout the spreadsheet and I need certain values to remain the same and some to change accordingly.=LOOKUP(A13,Centennial!A6:Centennial!A26,Centennial!E6:Centennial!E26) that is the code and I need the values of the ranges to stay the same(A6,A26,E6,E26) and A13 to change as i copy and paste. How do I keep those values constant?
 

A:Excel Programming Constant Value

use a $ sign to fix the position

A6

to keep the column from changing type

$A6

to stop the row changing type

A$6

to fix both column and row

$A$6

so for your look up range

$A$6.$A$26
 

Read other 3 answers
RELEVANCY SCORE 53.2

I want to use MS Excel for keep records of a warehouse. I have created an invoice with necessary formulas and it automatically calculates everything, writes the final total in words. Now I want to connect this invoice with a warehouse record to automatically keep records of invoices issued and to automatically reduce the quantity of goods from the warehouse. This should help me to find the availability of goods at the warehouse at any given time and also to see the sales progress.
The problem is I don't know the formulas to be used for this type of programming.
Please help me with some idea about the formulas to be used.
Thank you.
 

A:Microsoft Excel programming

Read other 11 answers
RELEVANCY SCORE 53.2

If this isn't the right section forum please let me know but I stumbled across this website and I cant tell what I'm doing wrong with the coding. In attachment.
 

A:Solved: Learning JavaScript coding, whats wrong with this code?

Read other 16 answers
RELEVANCY SCORE 53.2

Down Under we show our dates as dd/mm/yy. I have a user who types in 3/4/00 and the system automatically reverses the date to 4/3/00. I have checked the properties on the regional settings, and the date options in Excel are also correct. I have tried, in Tools/Options/Calculations to change the date format to 1904, but the system wont accept it.

Any ideas for resolution appreciated.

Ms. Kumara
 

A:(Solved) Excel date format wrong

In my 4 years in customer services for a well known computer company, I have never seen that before.

Microsoft Excel does not control the dates nor the settings, ie currency etc. Which version are you using?

Try using another Microsoft program like Word to see if you have the same problem, if not, then you would need to speak to Microsoft in New Zealand.

Also, double check to see under Regional Settings in Control Panel, in regional settings tab, make sure the setting is English (New Zealand), and press apply (if it is not greyed out. If it asks you to restart, press no and go to the Currency and Date tabs to make sure that the setings are for New Zealand.

If that fails, then you can *force* the machine to your own custom settings, by changing the values.

If all else fails, then it could be Windows itself.

Please email me to let me knowhow you got on.

James
 

Read other 2 answers
RELEVANCY SCORE 52.8

Hiya

This is the sample code for Microsoft® ASP.NET Programming with Microsoft Visual C#™ .NET Deluxe Learning Edition, 0-7356-1815-1.

System Requirements

To use the sample code files, you'll need the following:
Microsoft Windows 2000 (SP2 recommended), Microsoft Windows XP Professional, or Microsoft .NET Server
Microsoft SQL Server 2000 (Personal, Standard, or Enterprise Edition -- SP2 recommended) or the Microsoft SQL Server Desktop Engine (MSDE), included with Microsoft Visual C# .NET
Microsoft Internet Explorer 5.5 or later
Internet Information Services (IIS). To access the ASP.NET features, IIS must be installed prior to installing the .NET Framework.
The Microsoft .NET Framework Software Development Kit (Note: you don't need to install the .NET Framework SDK separately if you install Microsoft Visual Studio .NET)

Operating System - Windows 98, NT4 & 2000, Windows Me, Win XP

http://www.microsoft.com/downloads/release.asp?ReleaseID=43351&area=search&ordinal=11

Regards

eddie
 

Read other answers
RELEVANCY SCORE 52.8

Hiya

This is the sample code for Programming Microsoft® SQL Server™ 2000 with Microsoft Visual Basic® .NET, 0-7356-1535-7.

The book's sample files were developed and tested on a computer with Microsoft Windows 2000 Server, Microsoft SQL Server Enterprise Edition, and the Enterprise Developer Edition of Microsoft Visual Studio .NET. To use the sample files, you'll need to have Microsoft Visual Basic .NET or Microsoft Visual Studio .NET installed on your computer. In addition, you'll need Microsoft SQL Server 2000, and for some of the chapters you'll need Microsoft SQL Server 2000 updated with Web releases 1, 2, and 3. Chapter 6 of the book gives URLs for downloading Web Releases 1 and 2. Chapter 12 gives two different URLs for downloading Web release 3 -- one with the Microsoft SQL Server 2000 Web Services Toolkit and one without.

Operating System - Windows 98, NT4 & 2000, Windows Me, Win XP

http://www.microsoft.com/downloads/release.asp?ReleaseID=39542&area=search&ordinal=2

Regards

eddie
 

Read other answers
RELEVANCY SCORE 52.8

Hello All techies here,

I am very much new to this forum.I am aware that it is possible to send emails from Excel using VB programming but I am very much unaware of VB programming and tricks.

I am working on a work where I need to generate automated mails from excel via outlook based on the contents of the selected cell and some logics.

Here is the URL for image that will give some rough idea.

https://fbcdn-sphotos-d-a.akamaihd.net/hphotos-ak-snc7/s480x480/391681_552548121437857_52068638_n.jpg

or
https://fbcdn-sphotos-d-a.akamaihd....480x480/391681_552548121437857_52068638_n.jpg

or

from this sheet(shown in image) I want to generate mail with logic like this :
case 1) If i click on MSS in row ABC ,click on APD and then press " @ " then it should generate a mail like below and send it to [email protected] and cc : [email protected]

subject : "card request"

mail body
**********
Hello,

My name is ABC (i.e. A2 content).
I need to have some MSS card of APD type
value 1
value 2
value 3
if above cards are not present then we can also use VD
value 4
value 5
value 6

Regards,
Shashank1320
*************

case 2 )but if I press MCS in row ABC ,APD and then press @ then it should send mail to [email protected] and cc : [email protected]

subject : card request
mail body
*****
Hello,

My name is ABC (i.e. A2 content).

I need to have some MCS card of APD type
value 1
value 2
value 3

if above cards are not present then we can ... Read more

A:Email sending from Excel programming

Welcome to the forum,
I suggest you do a search for similar posts, give or take minor differences they all come down to the same solution.
Once you've found something taka a look and try it out.
 

Read other 3 answers
RELEVANCY SCORE 52.8

Hello to the members of Tech Support. This is my first post, so thanks in advance for the help! So here is goes.

-I have 9 worksheets with approximately 77500 rows and 23 columns of data between all nine.
-At the top of the worksheet I have a table data running from E7 to N7. This data is carried over from the previous month's data.
-Column AA has a formula: =Z13+(O13-Q13)*3340.4
Where Z13 is the first row where the data begins, and Z### is where the data ends. Rows of data vary from month to month. The formula carries on such that row 14 uses the same formula but insert 14 vice 13. The number 3340.4 is the number found in cell E7 and always the multiplier in the formula.
-Column AA on worksheet 2 requires the same formula. =Z13+(O13-Q13)*4567.3. However note that the 4567.3 is the next number over in cell F7 and is now the multiplier until the last row.
-Worksheet 2 has a different number of rows (which also varies from month to month.).
-The data for each month is always found in cells E7-N7.

Worksheet 3 would use date in G7 and so on....

Any help with the coding of this Macro would be greatly appreciated.
Thanks
Can someone help me with the macro to automatically
 

Read other answers
RELEVANCY SCORE 52.4

Mornin´, all.

My sister was working on a personal expense report using Excel 2003, when she noticed that doing an AutoSum on a column brought a wrong total. We checked the addition by calculator (twice) and noticed that Excel's total is 175 too much. The attached screencapture shows how Excel is giving 5,501.89 as the total sum of column D, but the correct addition should in fact be 5,326.89.

This has been a reappearing problem with other Excel projects she has worked on using this same Excel.

I have done some Google searches regarding Excel giving wrong figures, but found nothing that is applicable to my situation. I have the feeling that the answer to this problem is simple, but I just can't find it.

Thanks in advance for any suggestions!

Screen capture image:
http://thinkgardner.com/img/excel_screencapture2.png
 

A:Solved: Excel 2003 does wrong addition on AutoSum

Read other 7 answers
RELEVANCY SCORE 52.4

Hi I am getting weird exception and I dont understand why, I been struggling and no luck

When I load (download) an excel file with macro from a server to my desktop and open it
I get the below error message:

Run-time error '1004':
Unable to get the CheckBoxes property of the Worksheet clas

I noticed if I open and click save, close and open again the error is not there anymore.

Why is the error gone? I am not changing anything in the file, just save and open again.

Thank you for your help
 

A:Solved: Excel VBA code

It may be that the code is refering to a named object, which can only be in such state when saved rather than being opened from temp location.
 

Read other 1 answers
RELEVANCY SCORE 52.4

I have developed a small database in excel which utilizes a UserForm to collect information for new database entries. I have only limited understanding of VBA programming, so I need a little help on the code to perform the following function.

After I type in all the required fields in my UserForm, what code do I need to insert in order for the new entries to be inserted in the first empty row of the database? I know how to set the value of a cell to the data in the UserForm, but I'm not sure how to make the computer start from the top of the database and move downward until it finds an empty row, and then insert the entered data into the row.

Any help would be greatly appreciated!

Thanks
 

A:Solved: Excel VBA Code Help

Read other 9 answers
RELEVANCY SCORE 52.4

Hiya

This is the sample code for Programming Microsoft® Windows® with Microsoft Visual Basic® .NET (Core Reference), 0-7356-1799-6.

System Requirements

To use the Companion Content you'll need to be able to compile and run Microsoft Visual Basic .NET programs. The system requirements are as follows:
Microsoft Windows NT 4.0, Microsoft Windows 2000, or Microsoft Windows XP
AND
Microsoft .NET Framework SDK -- can be downloaded from the link provided above (Minimum)
OR
Microsoft Visual Basic .NET (Preferred)
OR
Microsoft Visual Studio .NET (Best for multi-language development)
To run your Microsoft Visual Basic .NET programs on other computers requires the .NET runtime (also referred to as the .NET Framework redistributable package) to be installed on those machines. The redistributable package comes with the Microsoft .NET Framework SDK, Microsoft Visual Basic .NET, and Microsoft Visual Studio .NET. The redistributable package can be installed on the versions of Microsoft Windows listed above as well as Microsoft Windows 98 and Microsoft Windows Millennium Edition (Me).

Operating System - Windows 98, NT4 & 2000, Windows Me, Win XP

http://www.microsoft.com/downloads/release.asp?ReleaseID=40364&area=search&ordinal=3

Regards

eddie
 

Read other answers
RELEVANCY SCORE 52.4

Hiya

This is the sample code for Sample Code: Programming with Managed Extensions for Microsoft® Visual C++® .NET, 0-7356-1724-4.

System Requirements

The first five chapters of the book require only the C++ compiler (version 13). The C++ compiler supplied as part of the Microsoft .NET Framework SDK does not produce optimized code, nor does it provide extensions like the unmanaged ATL Attribute Provider, but it is a fully featured C++ compiler that can be used for both managed and unmanaged C++ development. If you want to learn about the Microsoft .NET Framework, the C++ compiler is the place to start. The link provided above will connect you to the MSDN resource page for .NET, where you can download the Microsoft .NET Framework SDK.

The last two chapters of the book use features of Microsoft Visual Studio .NET. Microsoft Visual Studio .NET includes the full optimizing C++ compiler, and it also comes with unmanaged libraries: the complete CRT library, the standard C++ library, and the combined ActiveX Template and Microsoft Foundation Class libraries, all of which you can access from .NET code.

Operating System - Windows 98, NT4 & 2000, Windows Me, Win XP

http://www.microsoft.com/downloads/release.asp?ReleaseID=40404&area=search&ordinal=1

Regards

eddie
 

Read other answers
RELEVANCY SCORE 52

hi to all,

i'm writting a marco to populate the row and col in the spreadsheet. I provide an form interface for the user to key in the data before reflect the data in the spreadsheet. my question is how do i detect the first blank row and transfer the data into that blank row in the spreadsheet.

i only have 9 columns and therefore i hardcode the colum, however, i need to find the blank rows so as to insert the data.

Cells(currentRow, 1) = txtTime.Text
Cells(currentRow, 1) = txtDate.Text

can someone tell me how to fiind the index of the rows???????

Thank in advance
 

A:excel marco programming detecting blank row

The code you have writes txtTime and txtDate to the same cell. Try:

newrow = Range("A65536").End(xlUp).Row + 1
Cells(newrow, 1) = txtTime.Text
Cells(newrow, 2) = txtDate.Text

, assuming you have at least one row already.

I couldn't tell you what data type to use for newrow. Zack could tho', he might drop by later.

HTH,
bomb
 

Read other 3 answers
RELEVANCY SCORE 52

Question to the group:
I do a lot of intensive VBA programming within MS Access (2003 and 2010) for clients and have always programmed on PC platforms within Windows 2000, XP, 7 operating systems. Everything's worked just great. No problems.
I recently purchased a MacBook Pro and had Windows 7 installed on Bootcamp. I've installed MS Office 2010 and the installations are all humming along nicely and everyone seems to be playing well together.
My problem is that my existing Excel and Access applications that use VBA code generate boatloads of errors on the Mac platform (with Windows 7 running on Bootcamp). Attempts to program anything but the simplest VBA scripts also generate errors that do not appear on the PC platforms.
My questions are: Is this a problem with References or program/computer settings? Have other programmers tried to do the same thing I am doing and had the same problems? Is the Mac system simply incompatible with a Bootcamp/Windows/Office/VBA layering? Is there a solution? I can't find any other references to this problem in the searches I have performed so far. Any input would be appreciated.
Thanks in advance.
 

Read other answers
RELEVANCY SCORE 51.6

The attached workbook has code that takes the Excel data and generates an XML file. Everything works fine except one area.

When the code is ran right now, it creates an XML File that looks like this...

<data>
<student><id>1</id>
<name>Raymond</name>
<age>11</age>
<grade>
<mark>0</mark>
</grade>
</student>

<student><id>1</id>
<name>Raymond</name>
<age>11</age>
<grade>
<mark>95</mark>
</grade>
</student>

However, I would like the code to look like this...

<data>
<student><id>1</id>
<name>Raymond</name>
<age>11</age>
<grade>
<mark>0</mark>
</grade>
<grade>
<mark>95</mark>
</grade>
</student>

Any help in this matter will be greatly appreciated.
 

A:Solved: Excel 2007 Code

Read other 16 answers
RELEVANCY SCORE 51.6

Hello!!! I am out of my league on this one I am making an excel worksheet for work that will be constantly updated. To help me take the data and organize it easier I need a "date added" and a "date modified" automatically entered in (I wish I could rely on everyone in my office with inputting the data correctly but I'm not very optimistic about that). I have found a way that works to get the original date added but when I try and get the date modified to work all I get is different notification errors. I attached the file in case anyone knows an easier way to do this. Essentially the date added just needs to be linked to the First and Last name column and then date modified needs to be for the rest of the columns. Any and all advice is greatly appreciated!
 

A:Solved: Excel Code Question

Read other 9 answers
RELEVANCY SCORE 51.6

I have a spread sheet that is populated by an Access 2003 database. I have a series of Cells B29:L29 that are populated with numbers which are then displayed on a form. What happens is when one of the numbers is a 0 the numbers are not aligned when displayed. I'm thinking that is I could set another set of cells to search through the first set of cells to toss out the 0 and populate with whats left it would preclude the missalilgnment of the cells. I need some assistance with coding the cells to to this though.

Thanks
 

A:Solved: Excel 2003 code

Read other 9 answers
RELEVANCY SCORE 51.6

Hi all,

Have been tinkering with this rather good piece of code I found on interweb. I am really struggling with my limited VB experience and would like the amount returned to be an HLOOKUP or a VLOOKUP. Basically everything works perfectly but I would like the routine to look up say 'total' and then look at the next square and return that amount.

Any help appreciated. Code below

Sub SearchFolders()
Dim fso As Object
Dim fld As Object
Dim sfl As Object
Dim strSearch As String
Dim strPath As String
Dim strFile As String
Dim wOut As Worksheet
Dim wbk As Workbook
Dim wks As Worksheet
Dim lRow As Long
Dim rFound As Range
Dim strFirstAddress As String

On Error GoTo ErrHandler
Application.ScreenUpdating = False

'Change as desired
strPath = "c:\MyFolder"
strSearch = "Specific text"

Set wOut = Worksheets.Add
lRow = 1
With wOut
.Cells(lRow, 1) = "Workbook"
.Cells(lRow, 2) = "Worksheet"
.Cells(lRow, 3) = "Cell"
.Cells(lRow, 4) = "Text in Cell"
Set fso = CreateObject("Scripting.FileSystemObject")
Set fld = fso.GetFolder(strPath)

strFile = Dir(strPath & "\*.xls*")
Do While strFile <> ""
Set wbk = Workbooks.Open _
(Filename:=strPath & "\" & strFile, _
UpdateLinks:=0, _
ReadOnly:=True, _
AddToMRU:=False)

For Each wks In wbk.Worksheets
Set rFound = wks.UsedRange.Find(strSearch)
If Not rFound Is Nothing Then
strFirstAddress = rFound.Address
End If
Do
I... Read more

A:Solved: Excel 2003 VB code help

Read other 6 answers
RELEVANCY SCORE 51.6

I have a macro in excel which auto fills a specified column with the formula in the first cell.

Assuming that Row 1 contains my headers, the code looks as follows:

Range("M2").Select
Selection.AutoFill Destination:=Range(M2:M1845)

Is there a way instead of specifying the range to ask the macro to just carry on filling the formula until it reaches the end of the data entered, i.e. the last row of data?

I'm sure it was something like Range = xlDown, but every attempt seems to fail.

I am running Excel 2007 by the way.
 

A:Solved: Excel Macro Code

Try using

Selection.AutoFill Destination:=Range("M2:M" & Cells(Rows.Count, "M").End(xlUp).Row)

Rollin
 

Read other 2 answers
RELEVANCY SCORE 51.6

I have a workbook with at the moment 3 worksheets in it,once i have finished them,i would like to put some code in so that when the workbook is opened the vertical and horizontal scroll bars, the sheet tabs and the main bar along the top of excel, file,edit,view, insert etc are not visable or available, any idea's on what code to use please, i know i can go into tools - options and untick the scroll bars and sheet tab sections so these do not show but i can't find anywhere to unshow the top section, i would prefer this to be done automatcally when the workbook opens.

if possible could i then set up a macro on one of the worksheets(that i could password protect) that would restore these functions if i needed to alter any parts of the sheets at a later date

i do apologise for the long winded question
many thanks fo any help offered
 

A:Solved: Excel hide code

Read other 8 answers
RELEVANCY SCORE 51.6

Could someone please explain to me what exactly this code does?
Code:

With ws.Range("A2:B" & ws.Rows.Count)
LastRow = .Find(What:="*", after:=.Cells(1, 1), LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
End With
 

A:Solved: Explain Excel Code

Read other 7 answers
RELEVANCY SCORE 51.6

i have 6 checkboxes on a worksheet, what i would like to happen is depending on which checkboxes are checked and then a command button pressed, a particular worksheet will open i.e

checkbox1 and checkbox2 ticked = worksheet2
checkbox3, checkbox4 and checkbox5 = worksheet4
checkbox1 and checkbox3 = worksheet 5

etc
can anyone help with the code

thanks
 

A:Solved: excel checkbox code

Hi there,

Are you able to post your file? Also, please define all combinations and which action will happen. Also, I'm not sure, because of your terminology, what is going to happen. You say you want to open a worksheet, well, you can't do that. You can open a workbook, or you can activate a worksheet, but not open a worksheet. Does that make sense? Also, please make sure you tell us exactly what it is you are trying to do, the end result
 

Read other 2 answers
RELEVANCY SCORE 51.6

In MS Access you can write VBA code that allows you to manipulate the existing VBA code in standard and class modules by using the Modules collection of the application object.

In Access VBA, the Application.Modules collection contains only open modules

I am trying to do a similar same thing in Excel but with no luck.

There appears to be an undocumented Modules collection in Excel but the Modules.Count always comes back as zero. If this works the same way as in Access VBA, then none of the modules are officially "open" (including the one I'm executing).

Anyone have any experience doing this sort of thing in MS Excel VBA?

I just want to write some quick and dirty code to do some rudimentary analysis of an Excel application that was dropped on my desk. I want to do things like counting lines of code, and identifying the entry points and global declarations.

Yes, I can cut and paste all of the code into a text file and analyze that but I was looking for a more elegant solution.
 

A:Solved: How to get to Excel VBA code modules using VBA?

Read other 7 answers
RELEVANCY SCORE 51.6

Hi,

I'm a very new VBA user and have spent the better part of 2 day on this great website looking for a similar problem i've run into.

My problem is that i want information from "test" workbook~"results" worksheet to automatically update the "Tech Data" worksheet as well as export an update to the "Master" workbook.

FYI, two separate people input data: iron&manganese and Corrosion&scale inhibitor residuals. This data is exported to the 'results' worksheet and the same simple formula can be used to export to "tech data" worksheet. I am having a hard time getting the 'tech data' worksheet to export to the master workbook. I'm hoping someone can help me ensure the master file compiles all informaiton being exported to it. Note that the master file has several other headings as i was hoping to expand on the starter macro.

I created the tech data worksheet so data placement matched the master workbook format.
 

A:Solved: Excel-macro code help

Read other 15 answers
RELEVANCY SCORE 51.6

Hello to All!

Does anyone have a code/macro that will find a certain text in cells (*total) in a column, then based on the text found, search another column for the totals association with it, format the color & bold that total, and calc the sum in a 3rd cell?
Column 1 would have something like, abcTotals
defTotals
ghiTotals .........etc.
Column 2 ...something like, $63.00 (blue & bold formatting when found) ........ etc.
Column 3 would hold the sum of all the*Totals

Thanks!!!
 

A:Solved: Excel 03 Macro/Code

Read other 8 answers
RELEVANCY SCORE 51.6

Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas. This comprehensive Training Program explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. Whether you're a beginner, a power user, or somewhere in between this is your essential go-to for the latest on Excel formulas

Enrol This Course Now

PART=1
1. Workbooks (File) & Worksheet Handling
Excel Limitation

Excel Shortcut use and benefits

Excel Setting and Custom List Creation

Excel Tamplate and File Location System

Advanced Paste Special

Calulation with Paste Special

Link Data range as Picture Link

Loopkup Picture in Excel Worksheet

2. Advanced Formating for Reports and Dashboard
Formatting Triks

Date & Time For Trinks

Advanced Custom Formating (Number Format using Code)

Condtional Formatting

Advanced Conditional Formatting using Formulas

File,Sheets or Cells Protection Method

Benefits of Data Table or Cells Style

3. Data Handle and Data Analysis
Data Fill and Selection Method

Advanced Sorting and Filter Trinks

Data Summerization with Pivot Table

Calculation with Pivot table

Extranal Data Pivot Table

Relationship and Slicer in Pivot Table

Power Pivot in Excel 2016

Use SQL Query in Pivot Table

4. Page Setting and Form Creation
Drow Form in Excel Sheet

Hyperlink i... Read more

Read other answers
RELEVANCY SCORE 51.6

Hi there

I found an example on the internet on how to solve a linear programming problem using Excel 2000 Solver. I have attached a workbook with all the information you will need to solve the linear programming problem. I must be doing something wrong because my solution is different from the example I found on the internet. Here is the link to the internet example

http://www.ateneonline.it/chase2e/studenti/tn/6184-7_supA.pdf
 

Read other answers