Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: Problem with sumif

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Problem with sumif
I have a problem with the following code Code: --------- strFile = ThisWorkbook.Sheets("abc").Range("A1").Value 'where in range A1 i have the path of the workbook If strFile = "" Then strFile = SelectFile("A1") If strFile = False Then GoTo finish Set BasisRPT =...

Excel Help Forum - Excel General: Mail Merge: The merge results are not aligned properly

Feed2Mail notification - new post on Excel Help Forum - Excel General
Mail Merge: The merge results are not aligned properly
I hope someone can help please. I have created an excel spreadsheet as my data source (and a word document as the main document) so that I can create an enquiry response for guests seeking holiday accommodation. I simply enter the required dates, number of people (and dogs) that are coming...

Excel IT Pro Discussions Forum: Conditional formatting - Between 2 dates

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Conditional formatting - Between 2 dates

I want to return a specific color in a project plan. In column E I have the starting date and in column F I have the end date and starting from column H I have the specific dates.

My first task in the project is on row 5 and on row 2 I have the dates written so the first date is specified in cell H2.

On row 5, the first task I want to check for the start and the end date and I want the sheet to automatically put  a specific color in all the cells between those two dates.

I need some sort of in between formula :)

/Fredrik

/Freddie

Office IT Pro General Discussions Forum: Access 2010 and default database folder

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
Access 2010 and default database folder

We are running Office 2010 Professional Plus 32bit on Win 7 Enterprise.

We have a GPO to set the "Default Database Folder" to %HOMESHARE%%HOMEPATH%. When I go to File>New>Create, I receive the error, "%HOMESHARE%%HOMEPATH%\Database1.accdb" isn't accessible. the folder may bylocated in an unavailable location, protected with a password, or the filename contains a / or\. However, when I click on the "Browse" button next to the path, it will take me right to my homeshare\homepath location. The location is a network folder that is used for my home directory, and has all the correct permissions necessary for accessing the share.

Is anyone else having issues using environmental variables for the default database path? 

A+ NET+ Security+ MCDST MCITP

Excel Help Forum - Excel Charting & Pivots: [SOLVED] Can you graph a range?

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
[SOLVED] Can you graph a range?
I realize you can chart an upper and lower limit on the same chart, but is it possible to chart ranges of 3-5, 4-6 and such so that you get one thick line on your graph that covers the listed range. Hopefully I am being clear with my question. Thanks.

Excel Help Forum - Excel Programming / VBA / Macros: Why is the DatePicker control changing Sizes when I re-open File?

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Why is the DatePicker control changing Sizes when I re-open File?
Dear Excel Expert. My datepicker control in my Excel App (=EMBED("MSComCtl2.DTPicker.2","") appears very large every time I open the file. I am using Excel 2003. When I go to design view and adjust it, it stays the correct size but when I re-open the Excel file it's very large again. ...

Excel Help Forum - Excel General: Automatic Goal Seek

Feed2Mail notification - new post on Excel Help Forum - Excel General
Automatic Goal Seek
Hello everyone, I was wondering if anyone could help me with my Goal Seek problem. I have to manually set goal seek by opening the menu and selecting the cells every time I want to set a down payment or backward calculate a profit rate from a specific installment value. This gets rather hectic...
Subscribe to: Posts (Atom)