 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / January 2006Cell Mapping
Is there a way to quickly select multiple cells to equal one other cell?:confused:  SignatureMRSV Hello MSRV, Not certain what you want to do. Can you give an example? Sincerely, Leith Ros I am trying to create a template where I can use one cell to input variable and then have that variable automatically populate in man other cells. To do this one by one would be to = a cell to the cell want to input the variable in. I happen to have many cells that I wan this variable to populate in and I was wondering if ther is a globa command to accomplish this. I hope this did not confuse you more Hello MRSV, There isn't a global command to do what you want. To do this would require writing some code for the Worksheet_Change event. It would work lke this. When the contents of the cell change the event code fires and then saves the current cell's data into the other cell's you specify. The down side is you have to hard code the cells you want changed into the macro code. Would this be a workable solution? Sincerely, Leith Ross SignatureLeith Ross Hi Leith, Thank you very much for taking the time to investigate my query. I have been hacking away at each cell indvidually as I awaited responses and think that the best way forward is to stay the course. Thanks again, Steve SignatureMRSV |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.