entirerow

Hey Team, I have this code that highlights the entire row of the active cell. But I don't want it to mess with the cells I already have highlighted in that row. Is there a way to modify this to only highlight cells that are not currently highlighted?? This way my highlighted cells are not...

I need some help to fix this code to copy and clear content only in a range instead of copying and clearing the whole row. What the code does now, is that if column "I" is greater than column "J", in row 2-14, it copys the rows and PasteSpecial from row 16 and onwards. I want to copy only...

Sheets("Sheet1").UsedRange Dim Rng1 As Range For Each Rng1 In Range("Z:Z").SpecialCells(xlBlanks).Areas Intersect(Rng1.EntireRow, Range("A:BT")).Delete shift:=xlUp Next Rng1 ok so I have used this code many times but need to modify it a little...

Hi all, I'm sitting in front of a deadline project and I seem to be forgetting the basics.. my own name will be the next one.. I'm getting compile errors and I can't figure out the correct syntax. Sub try_this() Sheet4.Activate Dim headerrowin As Long headerrowin =...

Hi guys, I made this command, before it was working fine. I have been using it for quite sometime now. Sheets("DATABASE").Rows("4:1048576").Delete Now suddenly there is an error showing, I didn't change anything to my programming. Error 400. Tried this too in hope that it will get fixed...

Hi, I need to create a code that once I paste in some data, the code activates and looks down range("A2:A10000") (Or last row, the data will never go past 10000) and if a cell contains a "Y" then delete A2:J2 not entirerow. Example <tbody> A B C D E F G H I J 1 3 10 2 4 8 9 4 4 6 Y 4 7 5...

I am getting confused that why excel do the actions to all grouped sheets except this action that I really need it. I want to insert Row by selecting range of cells and then insert entire row. it makes me more confused that it works when I do it manually and also recording macro. I mean all...

I have written the following code to insert a new row so that an entry isn't overwritten: Range("B2").EntireRow.Insert The new row is inserted ABOVE the previous post. I would like to have the new row inserted BELOW the previous post. Thank you!

Hi, I have the following code for copying and pasting an entire row from one spreadsheet into another: Sub ExportRow72() 'Declare Variables Dim MyRange As Range, rng As Worksheet Set rng = Workbooks("2012 to 2016 bound new test VBA").Sheets("2015 CLASH") Set MyRange = Workbooks("Copy of...

I'm trying to copy and Paste an entire row from one workbook to another. Here is the code I have come up with but it is not working - I'm getting an out of memory error on the last row - any suggestions? Sub ExportRow4A() 'Paste Row from MCT Summary In to B&Q 'Declare Variables Dim...

I have 22 identical worksheets for a financial report used by our businesses where Col A has categories, Cols B-J are used for numbers, and Col K is for comments. Col K is configured to Wrap text (also, for 'TEXT ALIGNMENT', 'Left (Indent)' and 'Bottom' are selected). To print the report...

Hi guru's, I'm working on a bit of code to add a new row to a worksheet. The worksheet is for values related to electricity distribution. This particular code adds a new row to a list of equipment that is connected to a particular switchboard. When new equipment is added, the user will add...

Hi everyone, I am trying to write a macro that scans a selection of cells in one sheet and then cuts any rows from this sheet and pastes them into another sheet if the cell contains a particular text. As it stands I have two worksheets labelled "Data" and "Errors". On the Data worksheet I...

Hello People! I hope someone here can help me... I have made a macro that copies a row into a new sheet: Sheets("Datasheet").Select Range("A2").Select ActiveCell.EntireRow.Insert Shift:=xlDown Sheets("MailMerge").Select Range("A7:G7").Select Selection.Copy Sheets("Datasheet").Select...

I am working on solving a problem where I get every other row deleted instead of every row. The situation is that I am using Autofilter to find empty cells in a column that shouldn't have empty cells. Before I can delete them, I need to add them to an array for exceptions handling. This means I...

Hi All, Can someone please help with the following. I am using the following script which highlights the entire row of found values. I would like a modified script which would copy the rows of the found values into a listbox. Also a script which would copy not the entire row of the found...