hit

I am in a .xlsm file not that it would matter in this case. I press "Record Macro", perform an action like select a cell, put in a vlookup, or I could hit any simple action, hit stop recording, but all that I see in the code is: Sub Macro8() ' ' Macro8 Macro ' ' End Sub The body doesn't...

Hi I have a column with cells, some are blank because I hit delete and some are blank because i hit spacebar. Now when I filter this column-->Blank, excel will show me both types of cells (cells empty because i hit spacebar and delete). Now I am confused. I thought cell that empty because...

Hi I am trying to get to a point where my users can manipulate the data then force them to create a file name based on info retrieved from an input box and allowing them to select a path and save the file to a new location. I have it sort of working but it is throwing an error a type mismatch...

Spent the last 3 days attempting to find a VBA code or macro for the following: Have a Spreadsheet set up to use the Betfair IPA data to automatically ‘Back to Lay’ horse racing, it works fine and puts the Back and Lay bets on at the appropriate times, I then have Conditional Formatting set up...

All, I had a file I was working on it was on the network. We lost internet so the file messed up. It prompted to recover and someone, not me hit I have what I want. Can this file be recovered?

Hi Guys, Is it possible to do the following: If A3:A5 contains X then message box shows hit If K2:N2 contains X then message box shows hit If K10:K14 contains X then message box shows hit Else show Miss Thanks

I know this should be easy but for some..not so much for me have this code.. Public Sub LaunchGame_Click() If ChooseYourGameBox.Value = "Game1" Then ArcadeGames.Movie = "http://www.Game1.swf" ElseIf ChooseYourGameBox.Value = "Game2t" Then ArcadeGames.Movie = "http://www.Game2.swf" End If...

Hi, I have the following formula that works well, is there a way I can use it & take the 2nd 'hit' it finds? =IF(ISNA(MATCH(A6,'Yr6 Wk1'!$C$5:$C$252,0)),"",VLOOKUP(A6,'Yr6 Wk1'!$C$5:$D$252,2,FALSE))

Hi I am a newbie at excel and just joined an advertising firm. I have been a given a project to complete in excel and it's a bit difficult for me given my experience with excel and based on whatever I know I am pretty sure the task I am trying to automate using excel formulas is not easy. I have...

HI in column AD all of the sudden recently if I use text to columns in that column I get a pop up . There's already data here. So you want to replace it? I have text to columns in a code and I tried displayalerts= false and true, but that doesn't help cause that will have it hit ok and the...

Hi there, I have a workbook which is purely for user input ie. the user is just inputting data. Many of the cells are designed to hold large amounts of text (which are formatted to wrap text). However when many people type, they like to hit the {return} key to invoke a carriage return. Excel...

Hello, I am having a few issues with a for each macro I am working on. I am trying to compile information from forms in multiple worksheets into one list. The information I need is in the same cells on all the forms and I have recorded the macro I need from one of the sheets and I am trying...

I only know how to run and record. Trying to create button that pastes a preceding range to next available row, where every time the button is selected, in repeats same operation but to next available row: highlight row 1 - 10, paste to row 11. Hit button again, highlight row 11 - 21 and...

Hi All This is driving me crazy: In v14 if I go to a blank sheet and type anything and hit enter it's fine. In v15 if I do the same and hit enter, the workbook calculates. I tried this with the same workbook and I also disabled macros. It's a large workbook and takes about 15 sec to calculate...

I'm pulling data every minute from the web via api however occasionally a window pops up with an error message "DataSource.Error: Web.Contents failed to get contents" and everything stops. Once I hit the OK button on that window everything works fine again. I realize that occasionally I will...

This is my first time trying to write a macro and I am having a lot of trouble with it. I could really use some help writing this code properly. I am trying to create a search field that will search multiple worksheets and bring that data back to a range of cells. The customer will put in a...

I have a spread sheet that uses a user form, currently have to open the sheet, decide if you want to create or modify the part number, then when updated you have to hit enter 7 times to run the macros. I would like to be able to populate the part number column and when I click on it opens up...

I noticed something happening today with my workbooks. When I type in a cell and hit enter, the entire row below that cell is bolded. I type in the row below that again and hit enter and again, the entire line below that row is bolded. When I print, the line does not show but I have never...

Hi, Probably an easy question but the answer eludes me. I have a target that needs to be hit - 48,185. Weekly, I need to be hitting 2,878. So, 48,185 / 2,878 = 16.74. This would be the expected number of weeks it should take to hit the overall target. Now if my actual is less than 2,878 I...

Hello Everyone! I have a list of ID's in cell A1 - A50 on 'Sheet 1'. I have a summary page on 'Sheet 2'. I have a button on Sheet 2 that I want to pull the value in A1. When it is hit again, it shows A2. Again, A3 etc. Please let me know how this can be accomplished! Thank you!