• Insert Formula into Changing Last Column?

    So, I am at a loss on how to properly tell the macro to add the formula "Column B - Column on Farthest Right" and have it do it dynamically as columns of data are added. The columns that do contain data will never have a blank column between them, so that should make simpler but I am still lost. Any help is much appreciated. ... show more
    So, I am at a loss on how to properly tell the macro to add the formula "Column B - Column on Farthest Right" and have it do it dynamically as columns of data are added. The columns that do contain data will never have a blank column between them, so that should make simpler but I am still lost. Any help is much appreciated. Here is what I have: Sub InsertColumnFormula() Dim lastrow As Long Dim s As Range Dim r As Range Set s = Columns(ActiveSheet.UsedRange.Columns.Co... Set r = Columns(ActiveSheet.UsedRange.Columns.Co... + 1) lastrow = Cells(Rows.Count, "A").End(xlUp).Row Application.ScreenUpdating = False With Sheet1 .Range(r).EntireColumn.Insert .Range(r).Formula = "=B1-r" .Range(r).AutoFill .Range("s" & lastrow) End With Application.ScreenUpdating = True End Sub
    1 answer · Programming & Design · 7 years ago
  • WiFi Program to Switch between Receiver & Transmitter?

    I am looking for a program that I can put on my laptop through which I can switch the laptop from being a wireless receiver (so a normal wifi computer) to a wireless transmitter (when attached to a LAN line, of course). If anyone has any suggestions, they would be greatly appreciated. I know how to setup the WiFi hot spot/ transmitter with my... show more
    I am looking for a program that I can put on my laptop through which I can switch the laptop from being a wireless receiver (so a normal wifi computer) to a wireless transmitter (when attached to a LAN line, of course). If anyone has any suggestions, they would be greatly appreciated. I know how to setup the WiFi hot spot/ transmitter with my laptop but would like an easier way to switch between the two states.
    1 answer · Computer Networking · 7 years ago
  • Excel "VLOOKUP": Changing the array range in equation?

    I am wondering if it is possible to have the spreadsheet automatically change the array range for a VLOOKUP function when another function has properly located the value closest to zero. I have three columns. A has mL increasing as random intervals, B has a range of mV values starting at positive and then going negative, and C has the 2nd... show more
    I am wondering if it is possible to have the spreadsheet automatically change the array range for a VLOOKUP function when another function has properly located the value closest to zero. I have three columns. A has mL increasing as random intervals, B has a range of mV values starting at positive and then going negative, and C has the 2nd derivative value of dmV/dmL. I want my array to always start on the mV value nearest to zero (positive of negative, or positive if it makes it simplier) and continue its VLOOKUP into down the column. So far I have everything working except the automatically changing array range.
    3 answers · Software · 7 years ago
  • Excel "VLOOKUP': If reported value is less than 5, then change array range?

    So, I am working on a spreadsheet that you plug in a bunch of data point and the 'calculation box' looks up the maximum milli-volts and reports the corresponding mL. I have this part working just fine but what I am interested in doing is the following. I want the calculation to automatically reset its search array when the reported mL... show more
    So, I am working on a spreadsheet that you plug in a bunch of data point and the 'calculation box' looks up the maximum milli-volts and reports the corresponding mL. I have this part working just fine but what I am interested in doing is the following. I want the calculation to automatically reset its search array when the reported mL value is below a certain value, such as 5 mL. I can't just adjust the range of the array to examine less of a range because the mL dosed changes at different rates so changing the range of the array may end up cutting off important data. Thanks for any and all help. My current calculation statement: Column H: mV data points Column I: mL data points =VLOOKUP(MAX(H7:H82),H7:I82,2,FALSE)
    2 answers · Software · 7 years ago
  • Audio Book Suggestions- Fantasy Fiction?

    So, I am looking for a well produced audio book to listen to and when I say well produced, I mean that it isn't just someone reading the book into the mic. The person changes their voice for different characters. I am also looking for a fantasy fiction series. Previous series that I have loved were the 'Sword of Truth' series,... show more
    So, I am looking for a well produced audio book to listen to and when I say well produced, I mean that it isn't just someone reading the book into the mic. The person changes their voice for different characters. I am also looking for a fantasy fiction series. Previous series that I have loved were the 'Sword of Truth' series, 'Song of Fire and Ice', 'Codex Alera', and 'Ranger's Apprentice' series.
    3 answers · Books & Authors · 7 years ago
  • Salsa Dancing Instruction?

    My wife is a pretty good salsa dancing and has been teaching me over the past few months how to salsa, bachatta, rumba, waltz (which I can do very well), kumbia, cha cha, etc. I am looking for a site or instructional program that is online or purchasable to break down the moves of basic salsa and show me how to do them. I am kinda a scientific... show more
    My wife is a pretty good salsa dancing and has been teaching me over the past few months how to salsa, bachatta, rumba, waltz (which I can do very well), kumbia, cha cha, etc. I am looking for a site or instructional program that is online or purchasable to break down the moves of basic salsa and show me how to do them. I am kinda a scientific thinker, so direct instructional videos would probably work best. Thanks.
    2 answers · Dancing · 7 years ago
  • MMORPG Browser/Text based Medieval Warfare Game?

    I am looking for a game that my friend was playing a while ago but neither of us can remember the name. The system involved building buildings, training attackers & defenders, and you had a hero who could be a few different classes (thief, warrior, paladin, etc.) You could explore for land or invade other people's land for more acreage to build... show more
    I am looking for a game that my friend was playing a while ago but neither of us can remember the name. The system involved building buildings, training attackers & defenders, and you had a hero who could be a few different classes (thief, warrior, paladin, etc.) You could explore for land or invade other people's land for more acreage to build on (similar to dominon at kamikazegames.com). Any ideas, because I have been scouring the internet for this game.
    7 answers · Video & Online Games · 7 years ago
  • Logic Puzzle Type: Visual Pun?

    I was wondering if anyone could tell me the title of a certain type of logic puzzle (or even better, give me a link to a site that has some!). These logic puzzles are a single image consisting of letters, words, or numbers that you have to think about to come up with a common phrase or a simple object name. For example, a picture could consist... show more
    I was wondering if anyone could tell me the title of a certain type of logic puzzle (or even better, give me a link to a site that has some!). These logic puzzles are a single image consisting of letters, words, or numbers that you have to think about to come up with a common phrase or a simple object name. For example, a picture could consist of a 1/4 symbol except from back side of that symbol, therefore indicating 'quarterback' as the answer. Thanks!
    3 answers · Jokes & Riddles · 7 years ago
  • Mustard Seed's Asian Salad Recipe?

    I am looking for an Asian salad recipe that is similar to that made by Mustard Seed and Noodles Express. If anyone has any ideas about it, let me know. Thanks!
    I am looking for an Asian salad recipe that is similar to that made by Mustard Seed and Noodles Express. If anyone has any ideas about it, let me know. Thanks!
    1 answer · Cooking & Recipes · 8 years ago
  • Excel Question: Drop Down List Filling?

    I was wondering if Excel would do what some search engines do. You begin enter the name of something into the search bar (in the case of Excel, a drop down menu) and it begins listing all the matching words from the list (example: type Hear, and you get Heart, Hearth, Hear, etc.).
    I was wondering if Excel would do what some search engines do. You begin enter the name of something into the search bar (in the case of Excel, a drop down menu) and it begins listing all the matching words from the list (example: type Hear, and you get Heart, Hearth, Hear, etc.).
    1 answer · Software · 8 years ago
  • Who can help fix this excel equation?

    I am looking to fix this equation. If anyone can help me with it, I would be most appreciative. The equation will check for two of three items in two cells and list the third in another cell. The first two are input and must be different terms or an "error" should be shown. Also, all three terms should be shown in the three cells under... show more
    I am looking to fix this equation. If anyone can help me with it, I would be most appreciative. The equation will check for two of three items in two cells and list the third in another cell. The first two are input and must be different terms or an "error" should be shown. Also, all three terms should be shown in the three cells under all conditions (except when two of the same terms are placed within the input boxes). Code: IF(EXACT(B11,"Desired Conc. (M)"),(IF(EXACT(B12,"Mass (g)"),) "Volume (L)", (IF(EXACT(B12,“Volume (L) ”),) ”Mass (g) ”, “Error”)),) (IF(EXACT(B11,"Mass (g) "),) (IF(EXACT(B12,"Desired Conc. (M) "),) “Volume (L) ”, (IF(EXACT(B12, “Volume (L) ”),) “Desired Conc. (M) ”, “Error”),) (IF(EXACT(B11, “Volume (L) ”),) (IF(EXACT(B12, “Desired Conc. (M) ”),) “Mass (g) ”, (IF(EXACT(B12, “Mass (g) ”), “Desired Conc. (M) ”))))))))
    1 answer · Programming & Design · 8 years ago
  • Excel Help: Drop Down Menu to Change Spreadsheet?

    I am looking for a tutorial (whether written here or a reference/link to a website) that would show me how to change the contents of a spreadsheet upon changing a selection from a drop down menu in that spreadsheet. For example, you could list sports teams in the drop down menu, and upon selecting one, it would change the names in the roster on the... show more
    I am looking for a tutorial (whether written here or a reference/link to a website) that would show me how to change the contents of a spreadsheet upon changing a selection from a drop down menu in that spreadsheet. For example, you could list sports teams in the drop down menu, and upon selecting one, it would change the names in the roster on the page to match the team. Thanks for all help :)
    1 answer · Software · 8 years ago
  • Pantech Matrix: Picture Error?

    I have downloaded a picture from a friend's text message and wanted to apply it to their contact listing as the photo caller ID but the picture either doesn't apply or when i try to view the picture on the phone, the phone tells me the files is corrupt or not supported. The file is a jpg format which matches the working photos i have... show more
    I have downloaded a picture from a friend's text message and wanted to apply it to their contact listing as the photo caller ID but the picture either doesn't apply or when i try to view the picture on the phone, the phone tells me the files is corrupt or not supported. The file is a jpg format which matches the working photos i have taken with the cell phone camera. Any advice?
    1 answer · Cell Phones & Plans · 8 years ago
  • IPod Nano (5th Gen) Question?

    I am looking for which iHome device will working properly with the 5th generation iPod Nano (the iPod that captures video). I only have a classic iPod 5th gen but this will be a gift for someone with the 5th gen iPod Nano.
    I am looking for which iHome device will working properly with the 5th generation iPod Nano (the iPod that captures video). I only have a classic iPod 5th gen but this will be a gift for someone with the 5th gen iPod Nano.
    2 answers · Music & Music Players · 8 years ago
  • Sound Card ID and Problems?

    I am having trouble identifying the exact model number and other info of my sound card. Can anyone help me? Here is what shows up in the system info screen: Name Creative X-Fi Audio Processor (WDM) Manufacturer Creative Technology, Ltd. Status Error PNP Device... show more
    I am having trouble identifying the exact model number and other info of my sound card. Can anyone help me? Here is what shows up in the system info screen: Name Creative X-Fi Audio Processor (WDM) Manufacturer Creative Technology, Ltd. Status Error PNP Device ID PCI\VEN_1102&DEV_0005&SUBSYS_00331102... Driver c:\windows\system32\drivers\ctaud... (5.12.1.1201, 509.05 KB (521,272 bytes), 8/15/2007 5:17 PM)
    1 answer · Other - Hardware · 8 years ago
  • Finding out what Ram to Buy (Special Details)?

    I am trying to find a program I saw a bit ago that determined the type of Ram a computer had and how much more it can use (or how much it had & how much the max is) WITHOUT installing any program onto this computer. The computer is directly linked to an infrared spectrometer and numerous program can interfere with that link.
    I am trying to find a program I saw a bit ago that determined the type of Ram a computer had and how much more it can use (or how much it had & how much the max is) WITHOUT installing any program onto this computer. The computer is directly linked to an infrared spectrometer and numerous program can interfere with that link.
    1 answer · Desktops · 8 years ago
  • What are your favorite Psalms?

    I am looking to add a quote to a project with three crosses, a larger, more intricate one in the middle with two identical smaller ones (one on each side). It is going to be a gift for my father. So, what is your favorite psalm or biblical verse that may apply to this project.
    I am looking to add a quote to a project with three crosses, a larger, more intricate one in the middle with two identical smaller ones (one on each side). It is going to be a gift for my father. So, what is your favorite psalm or biblical verse that may apply to this project.
    2 answers · Religion & Spirituality · 9 years ago
  • Japanese Translation?

    Could anyone translate "is alone and determined to stay that way." into Japanese? My friend wants it translated but i am not that good at translating yet.
    Could anyone translate "is alone and determined to stay that way." into Japanese? My friend wants it translated but i am not that good at translating yet.
    2 answers · Languages · 10 years ago
  • Any Good Mixing Recipes for Irish Cream & Scotch Whiskey?

    I currently have Bailey's Irish Cream and Macallan's Scotch Whiskey. Any possibile suggestions for mixing the two?
    I currently have Bailey's Irish Cream and Macallan's Scotch Whiskey. Any possibile suggestions for mixing the two?
    4 answers · Beer, Wine & Spirits · 1 decade ago
  • Cherry Sobe: What to Mix With It?

    I am just looking for some good ideas for alcoholic drinks to make with Cherry Sobe.
    I am just looking for some good ideas for alcoholic drinks to make with Cherry Sobe.
    7 answers · Beer, Wine & Spirits · 1 decade ago