Re: $$Excel-Macros$$ Help - Recorded Formula Not Ending Up In Cell Correctly

ange R[-7] to R[-6] like below: > =IF(AND(R[-6]C[-5]<>R[-7]C[-5].. and rest yourself. > > On Sat, Mar 31, 2018 at 4:55 AM, Johnny <fle...@gmail.com > > wrote: > >> Hi All, this is the strangest problem I've ever had with inserting a >> formula into a cel

$$Excel-Macros$$ Re: Help - Recorded Formula Not Ending Up In Cell Correctly

I included a small file, with sample data in it, and the macro I'm working on. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

$$Excel-Macros$$ Re: Filling in blank cells with names

: > Sorry, copy and paste missed the "S" in first line of Sub and simply says > "ub". > Thanks, David > > On Sunday, March 11, 2018 at 9:20:14 AM UTC-7, Johnny wrote: > >> Hi all, >> >> As an example, I have the name "John" in c

$$Excel-Macros$$ Filling in blank cells with names

Hi all, As an example, I have the name "John" in cell C4. Further down in C8 I have the name "Jeff". Using a VBA script, I'd like to loop down the C column, and fill in the blank cells between these names with the last name found. Before: John Jeff Tony After: John John John John Jeff

$$Excel-Macros$$ Trouble with VBA line break

I'm having trouble breaking this line in VBA. Range("T2").FormulaR1C1 = "=COUNTIF(RC17,""<94"")+COUNTIF(RC18,""<89"")+COUNTIF(RC19,""<90"") _ +COUNTIF(RC12,"">3.46"")+COUNTIF(RC13,"">2.82"")+COUNTIF(RC14,"">2.44"")+COUNTIF(RC15,"">2.31"")+COUNTIF(RC16,"">2.67"")" I put the space and

Re: $$Excel-Macros$$ Need Help please - Type Mismatch on rows insert macro

t; > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Friday, June 2,

$$Excel-Macros$$ Need Help please - Type Mismatch on rows insert macro

Trying to insert a blank row between each line. The line starting with: Rows is getting a type mismatch error. - Dim bottom As Integer Dim r As Integer bottom = Cells(Rows.Count, "A").End(xlUp).Row For r = bottom To 2

Re: $$Excel-Macros$$ Help with Proper Syntax for Range function with variables

Thank you Ashish it works perfectly. I will save this info so I don't repeat my question in the future. Much appreciated. -- John On Friday, November 4, 2016 at 4:08:49 PM UTC-4, ashish wrote: > try > > Range("A" & bottom & ":M" & bottom).Select &

$$Excel-Macros$$ Help with Proper Syntax for Range function with variables

I searched for the answer to this before posting. I know what I'm trying to do can work, it's just that the syntax is kicking my butt I find the bottom row number (in my case 462) using Column E in this example, and I'd like to select the Range from Column A to Column M with that row

$$Excel-Macros$$ VBA - checking for success of a Global Replace

One of the first steps in my macro does a global replace, looking for "BLKY046**" and replace it with "LKAREA". I would like to use this Replace as a means to keep the macro from running again if it has already been run once. Basically, if the Replace can't find "BLKY046**" it means I already

Re: $$Excel-Macros$$ Copying data into a cell with Conditional Formatting already applied

times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Tuesday, April 12, 2016 1:23 PM, Johnny <fle...@gmail.com > > wrote: > > > > Hi All, I searched for an answer on this first but I'

$$Excel-Macros$$ Copying data into a cell with Conditional Formatting already applied

Hi All, I searched for an answer on this first but I'm hoping for some easy, good advice. Using VBA, I have preloaded some cells with formula-based conditional formatting. When I copy a column of data into these cells, the conditional formatting does not take effect. Also, formulas in

$$Excel-Macros$$ Running a macro on multiple worksheets (code included)

Hi all, I've read through several threads to come up with the code below, regarding having a macro operate on all the worksheets in a workbook. I hope I'm missing something simple here. The workbook has 14 tabs, but the code only runs in the tab where I initiate the macro. Any help is very much

$$Excel-Macros$$ Delete the Rows Between the Last Row in Column A and the Last Row of Column B

As Integer Dim lastrowC As Integer lastrowB = Cells(Rows.count, B).End(xlUp).Row + 1 lastrowC = Cells(Rows.count, C).End(xlUp).Row Rows(lastrowB:lastrowC).Select Selection.Delete Shift:=xlUp End Sub Any help would be greatly appreciated. Thanks Johnny

Re: $$Excel-Macros$$ Delete the Rows Between the Last Row in Column A and the Last Row of Column B

Hi Don, thanks for responding. I inserted one of your examples: Rows(lastrowB : lastrowC).Delete and I'm getting Compile Error Syntax Error. I tried moving around the and such, but couldn't figure it out. Thanks Johnny On Mar 9, 3:13 pm, dguillett1 dguille...@gmail.com wrote: try Rows

$$Excel-Macros$$ Re: Excel 2010 problem - Need to work with 15 + digits

then the data should be highlighted. In the column data format click Text. Then finish. That should solve it. Johnny -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

Re: $$Excel-Macros$$ Formula Needed to Extract Data

Ash Can you post the VBA code? I downloaded the example but it is not in the workbook. I need to use a similar code for data extraction also. This code might help me, too. Thanks Johnny -- -- Some important