Hi

Hello all,

I am writing a user-defined function "GetAddress".

This function takes only one argument as input, a range in a worksheet, then it returns a String - the address of that range.

For example, I would like

GetAddress(B1:B10) to return "B1:B10"

GetAddress($B$1:$B$10) to return "$B$1:$B$10"

GetAddress(B1:$B$10) to return B1:$B$10

GetAddress(sheet2!B1:$B$10) to return "sheet2!B1:$B$10"

Hello all,

I am writing a very easy user-defined function "GetName".

This function takes only one argument as input, a user-defined name in a worksheet, then it returns a String - the name of that name.

For example, users have defined a name "List" which refers to B1:B10 on the worksheet. I would like GetName(List) to return "List" as String.

Could anyone tell me which function i should use in VBA to do so? It seems that .Name or .RefersTo cannot do it...

Thanks and regards

hello Nick, IT IS Amin. i like your Blog ;)

i'd like to know how can i build a report which can give me all the items which evoluated between 2 files.

example file 1

company Sales

ABC 200 Euros

bcd 100 euros

File 2

company Sales

ABC 250 euros

bcd 100 euros

here we see an evolution of 50 euros for company abc.

every time i get the latest file, i compare it with the file before. I use VLOOKUP function to determinate if there is a gap. what can you suggest me? arhardisse@hotmail.com

I need help on how can I extract multiple information from one cell given this data:

 This is the code that I am using 

conn.Open "Provider=MSDASQL.1;Server=VISHESH-NC\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=SSPI;", "abc", "abc" 

This gives the error: 

Err No. -2147217887 

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. 

on changing the command to 

Can somebody come up with a shortest possible code to get a list of unique out of a range ? Suppose you have data in Column A which contains duplicates. I want a list of uniques in column C. How is that possible with minimum of coding (but with coding only) ?

This is the sheet that's made for the Running Total topic

How can I create links between pages in a workbook? For example I have a workbook with over 100 sheets. On the first sheet I want to create a summary page with links in all the cells to each page so you can just click and it takes you to sheet 100 or 75 or whatever. Then vice versa to get back to summary page from sheet 100 or 75.

Rachelle.

Hi I am working on creating a cheque template for work and I need to know which formula to use that will copy data from the original cell I enter it into to mutliple cells on the worksheet.

I want to use this formula to decrease the amount of error that could possibly occur with the data entry. For example: If I type John Smith's name in the first box which will appear on the pay stub portion of the cheque template then I want it to copy onto the cheque as well. Or if I  type the cheque number it needs to appear in at least 3 locations on the template.

 I have inherited a list of products with names like these:

1117_Pit_Bull_Blue_Pointy.jpg

106-A-gymnast-child-girl.jpg

109Bgolfchildgirl.jpg

I am trying to sort these in Excel with no luck. The thousands end up mixed-in with the hundreds. I've tried changing the column to "numbers" but it doesn't appear to change anything. Is there a way to get Excel to recognize these leading numbers AS NUMBERS and sort them ascending and have the thousands end up AFTER 999?

Thanks!

JoeL
Atlanta, GA

Hi,

Is there a way to know whether the cell has an image ... If it has can I get the size of the image and then mark the result as number (o or 1).

Best regards
Hassan

 Does anyone know how to have the filters displaying filtered values but filter arrow marks (combo like) invisible making the excel sheet look like a plain sheet.

Im trying to create a sheet that essentially saves entered data into a seperate sheet dependent upon which type of data is entered.

Ex. Customer Service problem

      The user enters what type of problem from a list in an existing sheet:

               1. manufacturing defect

               2. Vendor issue

Just Check the attached sheet and run it in Excel 2003, 2007 & 2010 beta. Double clicking on any of the charts in 2007 will crash Excel. Uncomment the lines commented in the sheet code and you will find that it runs fine in Excel 2007 too.

I am trying to create a simple excel programme, where in one of the cells i will have the options (list of names) to choose from once i clicking once.

I have attached an example of it, under the cell "YES/NO" once u click, a small arrow appears next to the cell, where u can choose either YES or NO from a list.

So i was wondering, if there is any guide i could follow in order to achieve it or if anybody can help me.

I relatively new in EXCEL programming, so i believe that for EXCEL Experts it wont be so difficult.

is there a way to make a scrollbar scroll through decimal values? I want it to go from 0 to 100 by 0.1. It appears that only integers are allowed as the change values.

This may seem a silly question but how do you get a running total to work form one Work Sheet to another from a daily list to a monthly list, this =DailyBirdList!$B$3 updates the monthly list but will not keep a running total, I have tried lots of way but it will not work.

I 'm working on something for kids - using excel/macros - and part of it will calculate their ages in days.  I can manage this calculation ok.

Because they're quite young, I'm not sure they will have the ability to enter their dates of birth correctly and thought if they could enter date, month and year in individual cells, there would be a smaller chance of mistakes.

Is there any way of combining the data of the d, m, and y celss into one cell where it can then be read as an actual date and subtracted from today's date?

Hi I,v got stuck with this I am trying to get this to put a number that is generated in sheet1 onto sheet2 that works OK, the thing I can't get to work is to put the number into each month as it changes is this possible. all so can I make the month invisible in the out put.

This is the formula I have used

=TEXT(TODAY(),"MMMM")&'[Daily Garden Bird List.xlsx]Sheet1'!$B$30

Output = January9 (9 being the out put of sheet1)

The formula in sheet1 is =SUM(B3:B29)

I have attached a image of the screen.

In this topic i've placed my excel sheets to ber linked to several answers.

Only xls is accepted not xlsx or xlsm.?!?!?!

Dear Esteemed Excel Experts - I need add a single graph for these 5 different tabs of surveys to show the percentage contribution to each category (See attached file) The Radar Type doesn't work out that well!

PLEASE HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Does anyone know what a gembox spreadsheet is ?

I have a list of list of data that has a column with duplicates.  I have sorted all of my duplicates together abc by number.  These two duplicates have also been color coded, one record is red and other is green.  I have put my red record on top.  However, I want to use a piece of the green data to fill in a cell on the red data.  For example

Hi All

If someone out there could point me in the right direction it would be greatly appreciated!

Scenario:

I want to create a dynamic list of all of a particular day of the week (sunday in this case) referencing one cell containing the year.

For example cell A1 contains 2010 (next year)

The dates returned could be in A2, A3, A4.............etc

I would like the list to display in the format:

3/1

10/1

17/1

24/1

31/1

7/2

14/2

etc...etc

Any help is appreciated...Thanks

Anybody know what this formula means?

=SUBTOTAL(109,[Meals])

You'll see this (and others like it) if you open the built-in template named ExpenseReport found in Excel 2007. 

Presumably, Meals is a range name, but it doesn't turn up in the list of range names for the workbook.

Any what do the brackets mean? The Excel Formulas Book (by John Walkenbach) is a pretty good source for all things formula-related, but he says not a word about it.

Any ideas?

I'm using Excel to schedule employees shifts at my restaurant.  Column A is their name, Column B is their start time, Column C is their end time.

I'd like to be able to count the number of employees working during any given hour of the day to assure I've got enough staffing each hour.

I'm thinking it will require a COUNTIF function but I can't figure out how to make it work.  I've attached the sheet if that helps.