eggyu74

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.Count)

Set r = Columns(ActiveSheet.UsedRange.Columns.Count + 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

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.

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.

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)

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.

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.

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.

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!

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 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 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) ”))))))))

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 :)

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?

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 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&REV_00\4&12A7A555&0&20F0

Driver c:\windows\system32\drivers\ctaud2k.sys (5.12.1.1201, 509.05 KB (521,272 bytes), 8/15/2007 5:17 PM)

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 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.

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.

I currently have Bailey's Irish Cream and Macallan's Scotch Whiskey. Any possibile suggestions for mixing the two?

I am just looking for some good ideas for alcoholic drinks to make with Cherry Sobe.