I'm trying to write a macro to select a cell, move to the end of the cell,
press enter, and move to the next cell in that row & then repeat for all rows
in that column. Here's what I have so far.
Re: How to capture Max cell value (High Water Mark) ... a look saving the value and initializing it on worksheet open.... addressing whatever cell was active on the worksheet. ...Sub Test_Enable_Events ... I'm only using it on the same worksheet where the macro was created. ... (microsoft.public.excel)
Re: How to capture Max cell value (High Water Mark) ... Where A1 is the cell that is changing and the HiWater function can be in any ...Sub Test_Enable_Events ... I'm only using it on the same worksheet where the macro was created. ... (microsoft.public.excel)
Re: macro to copy range ... H. Frank Situmorang... I do not need the macro upto...Sub CopyC4ToNewRow()... formula in C4 into the first blank cell after the last piece of data in ... (microsoft.public.excel.worksheet.functions)
Re: Conditional Page Breaks ...andy wrote:> Hi Frank, ... When> I ran the macro against the full data it gave me an "Out> of Memory" dialog box, and when I debug the code, it had> stopped at the following: ... >> End Sub... I would like the code to>>> look at a cell and compare the>>> value in B10 to the value directly below it. ... (microsoft.public.excel.misc)
Re: macro to copy range ... I do not need the macro upto here. ... Are you looking to simply copy the exact formula in C4 into the single cell...Sub CopyC4ToNewRow()...Dim CopyToThisRow As Long ... (microsoft.public.excel.worksheet.functions)
