Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sheet formulas and strings
Hi!.... this is a two part newbie question:
1) if any cell has the following data: "sheet" & A1 (where cell A1 contains an integeter value), does Excel merge the string and integer value into a single STRING?? For example, if A1 holds an int value of 3, will Excel convert the entire expression into a string value of "sheet3"??? 2) Does excel have a function that will convert a string value into a sheet reference??? I seem to be having problems with the following formula: ("sheet" & A1)!F1 + F2 Basically, my sheets are labeled sheet1, sheet2 and sheet3, and the above formula is supposed to select a sheet based on the contents of cell A1. Can ("sheet" & A1) somehow be converted to a sheet pointer or something?? Hope that wasn't too confusing! Thanks so much! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sheet formulas and strings
I answered this question in the other newsgroup you posted it in.
For your future consideration, from a post by Jeff Johnson... "You have posted this question individually to multiple groups. This is called Multiposting and it's BAD. Replies made in one group will not be visible in the other groups, which may cause multiple people to respond to your question with the same answer because they didn't know someone else had already done it. This is a waste of time. If you MUST post your message to multiple groups, post a single message and select all the groups (or type their names manually in the Newsgroups field, separated by commas) in which you want it to be seen. This is called Crossposting and when used properly it is GOOD." Some additional comment previously posted by me: "You may not see this as a problem, but those of us who volunteer answering questions on newsgroups do see it as a problem. You can't imagine how annoying it is for a volunteer to read a question, research background material, test sample code and then formulate and post an answer to the original question only to go to another newsgroup and find the question posted and ALREADY answered over there. On top of that, if you cross-post your question, all of the readers in all the newsgroups it is cross-posted to see both the original question and all of the answers given to it. This is beneficial to you because then we can add additional material to, add clarification to, as well as add additional examples to an answer you have received previously... that means you end up with a more complete solution to your problem. This is a win-win situation for all of us." Rick "Robert Bencomo" wrote in message ... Hi!.... this is a two part newbie question: 1) if any cell has the following data: "sheet" & A1 (where cell A1 contains an integeter value), does Excel merge the string and integer value into a single STRING?? For example, if A1 holds an int value of 3, will Excel convert the entire expression into a string value of "sheet3"??? 2) Does excel have a function that will convert a string value into a sheet reference??? I seem to be having problems with the following formula: ("sheet" & A1)!F1 + F2 Basically, my sheets are labeled sheet1, sheet2 and sheet3, and the above formula is supposed to select a sheet based on the contents of cell A1. Can ("sheet" & A1) somehow be converted to a sheet pointer or something?? Hope that wasn't too confusing! Thanks so much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas are becoming text strings | Excel Discussion (Misc queries) | |||
sheet formulas and strings | Excel Worksheet Functions | |||
Need formulas for finding text strings | Excel Programming | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
converting concatenated text strings into formulas | Excel Worksheet Functions |