Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
David Z
How to prepare for low voltage landscape lighting prior to a driveway being poured?
I have a new concrete driveway being poured in 2 days. How could I prepare for low voltage lighting that must run under the driveway? There is no time for entire system to be installed so should I simply run some 10 gauge wire under driveway before it is poured so we can use it later?
Alternatively would it be a good idea to install a 2" diameter PVC pipe under driveway prior to pouring to use later to run conduit through?
6 AnswersDo It Yourself (DIY)6 years agoexcel macro to hide rows based upon all columns being zero or no value?
Prior to printing a financial statement I am looking for a macro to look to rows 24-41 and if any of those rows in which there is a 0, or no value in every column E:Q I want the macro to hide those rows.
In other words if all columns E:Q are all blank I wish the row to be hidden.
1 AnswerProgramming & Design7 years agoHow to automate pdf creation from Excel?
I am trying to automate the creation of a set of financial statements monthly. I have multiple tabs in an excel file I want to print to a pdf. I use Adobe Acrobat X Pro.
If I use the "create pdf" feature from excel add in it gives me ability to select which tabs I wanted printed and reorder them. However I cannot determine how to save these settings. Once I close Excel I lose the tabs that have been selected and have to go thru the process again. How can I set up a routine that I can run again and again?
I am not looking for an excel macro solution. I can do that if I must but adobe must have a solution a well.
1 AnswerSoftware9 years agoExcel tab reference question?
Is there a way to make a reference to a worksheet tab dynamic? In other words if I have tabs named summary, Jan, Feb and Mar
On summary tab I want to reference cells in Jan, Feb or Mar. but I want reference to look to a column heading in summary tab to determine what other tab to go find data. By changing column heading I want to look to a different tab for result.
Can anyone help?
2 AnswersSoftware1 decade agois it best to use ethernet or wireless to connect blu ray to internet?
I have a Samsung blu ray sitting next to my comcast cable box. I have my blu ray connected to internet now thru my wireless router. Would ethernet connection thru comcast box be better option to connect blu ray to internet? (e.g. would it be faster for updates or streaming content such as MLB?)
3 AnswersComputer Networking1 decade agoWhat garden pond plants are best for zone 5?
I have about a 350 gallon pond with a waterfall. The pond is lined.
What plants can be used with a lined pond given there is no soil at bottom to plant anything in?
3 AnswersGarden & Landscape1 decade agoexcel macro to delete rows containing non values?
I need a macro that deletes rows with a non value in column C and D. If there is a value in either column I want the record to remain. Only if both columns are non values does the row need to be deleted. I would prefer to not have to specify the range. Sometimes I may have 100 rows and othe times 200,000 rows. I want the macro to work regardless how many records are on the worksheet.
1 AnswerProgramming & Design1 decade agoany restaurants serve brown rice?
anyone know of any national chain restaurants that serve brown rice?
7 AnswersOther - Dining Out1 decade agoExcel macro delete rows if a cell equals a certain logical value?
I want a macro to delete all rows in which a logical value of FALSE is in the cell in Column A. I want it to begin searching with row 11 and move down until it finds no more data.
Note that FALSE is not a text value but is a logical expression of an AND statement.
8 AnswersProgramming & Design1 decade agoexcel macro to move cell contents down 1 row if criteria is met?
I need a macro that looks in Column A for any cells that begin "***TOTALS FOR" and when it finds it moves the contents down 1 row. The macro should continue all the way down Column A until no more data is found.
Any help will be appreciated.
6 AnswersProgramming & Design1 decade agoresidenial phone wiring?
My phone lines are dead in a home I just purchased. I need help trouble shooting. I use VOIP so I have unplugged the customer side of phone box. my VOIP works but when I plug in to home wiring I get nothing.
I have checked a few jacks to make sure red and green are wired the same.
Any suggestions on what I can try? I should be able to plug VOIP into home wiring for all the jacks to work.
4 AnswersLand Phones1 decade agoexcel macro command to allow user to select file to open?
How do you allow the user to run a macro but prompt the user to select the file to open? The macro would then continue running after the user has selected the appropriate file. I have the macro working but it requires the file name to always be the same. I would like to have the user be prompted to select the file to open.
3 AnswersProgramming & Design1 decade agohow to run different Excel macros one after the other?
I have built a series of macros; Macro 1, Macro 2, Macro 3 and so on. How do I instruct excel to run Macro 2 when Macro 1 is done running?
When writing them I tend to break down the project into smaller pieces.
I would prefer not to merge them together.
3 AnswersProgramming & Design1 decade agoExcel macro to delete rows if a column contains certain text?
I want to delete all rows in a worksheet if the text in column D begins with "CURRENCY". It will be included in the leftmost 8 characters of that cell if it exists.
This only need to be for the active worksheet.
2 AnswersProgramming & Design1 decade agofuel sender for 2001 Olds Silhouette?
I have a faulty fuel sender and am wondering if I can replace just the sender or is it incorporated in the fuel pump assembly?
1 AnswerGMC1 decade agoWhat is pricing structure for commercial real estate brokers?
Is there a range of commissions or fees most commercial real estate brokers use? For example residential real estate varies but is between 5-7% depending upon the area of the country.
Could someone provide a rough outline of commercial real estate broker pricing?
3 AnswersRenting & Real Estate1 decade agoAdvice on Magic Jack vs Vonage?
I have been a Vonage user for 4 years and went to them because of price. Now along comes Magic Jack and again I am considering a move because of price.
Does anyone have any feedback on Magic Jack phone call quality vs Vonage.
4 AnswersLand Phones1 decade agoFront wheel bearing hub assembly?
Is there a legitimate reason why a mechanic would suggest I replace both left and right front wheel bearings when the only 1 acting up is the right side bearing? 99 Olds Bravada.
I am suppling the part so mechanic is not attempting to sell me 2 parts when I only need one.
There is an ABS sensor in Hub assembly.
4 AnswersMaintenance & Repairs1 decade agoIndoor batting cages in Grand Rapids, MI?
Are their indoor batting cages in Grand Rapids, MI?
1 AnswerBaseball1 decade ago