startcell

Hello, Have the following code which works except it highlights the entire area it posted the data after doing the macro instead of just staying where the cell originally was. How can I get it to stay on cell B2 after running this code? Private Sub Worksheet_SelectionChange(ByVal Target As...

Hi This code is working but only copying 2 rows down instead of grabbing all till last data row? I think it's to do with the offset or the columns /rows set but don't know how to solve? Sub TransposeToMergedCells() Dim StartCell As Range Dim DestCell As Range Set StartCell =...

I have a macro that emails a selection however it also emails the hidden cells in that selection. I gather I am going to need to use SpecialCells(xlCellTypeVisible) however I have no clue where I am going to have to place it. Any help/guidance you can offer would be greatly appreciated!!! Sub...

I am trying to copy the dynamic range of data from one worksheet and place it into StartCell range in the destination spreadsheet with the StartCell range beginning in Cell ("A11"). The copying of the dynamic range for the data within the copy worksheet is working. I am struggling and need...

Hi I am trying to loop through worksheets - all with numerical worksheet names and then loop through a range of cells and add some prices. However, I am getting an error each time. I will say though that if I start to run the code when I am actually in one of the relevant worksheets then it...

For some reason my loop is creating duplicate outputs. If anyone can help understand why, I would be grateful Sub IPutil() Dim LastRow As Long Dim LastColumn As Long Dim StartCell As Range Dim frow, lrow, fcol, lcol As Integer Dim rng, MyCell As Range Dim sh1, sh2, sh3 As Worksheet Set sh1...

Hi all - Im trying to resize my chart but this aint working coming up with the error message "the item specified werent found" Here is the code Public Sub test2() Dim rngPaste As Range Dim StartCell As Long Dim EndCell As Long Worksheets("Daily1").Range("C195:E200").ClearContents...