if function in a macro

Hi there! My apologies if this is lesson 1 VBA however, I am a complete beginner at this. I have the following code that works, however, I am required to click somewhere in the worksheet for it to complete the run. The first section works fine, as soon as I click the F8 cell the F9:F20...

Hello, What would be the proper way to write the following in VBA language? if Window1,Sheet1,Range A1 = Window2,Sheet2,Range A2 then exit sub end if What I am trying to do is a macro that if a cell in a workbook is the same as another cell in a different workbook, the code will exit. The...

Hi All, I have a sheet with columns Amount, City and Name. I have a set of names for each location ex: North - Mr.X, Mr.Y, South - Mr. A, Mr. B, East - Mr. D, Mr.F. And a few cities in each of the locations Like North - Boston, Detroit Etc. Can Anyone please help me to provide a if condition...

Howdy ya'll! I am writing a program that utilizes a table on sheet 1, to do countif formulas and percentages on worksheet two in the same workbook. I have this base part set up, but am having trouble with error handling. Background: I am using polling data that changes constantly-the number of...

I'm trying to run a macro or function so that if any cell in a certain column is selected a message will appear in a different cell. So: If cell A6 is selected, Cell A1 will say: A6 selected If B10 is selected, cell A1 will say: B10 selected

Hi, I been working on a macro that highlights all blank cells in a row till the end of a variable range (the number of rows are variable but the columns are limited from A:AI) to be highlighted in purple background using conditional formatting. What I am struggling with is that I need a macro...