Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Excel Macro; move row

Comment:

I am trying to make a macro that will move an entire row to another sheet based on a value of 1-4 in column G. For instance if colG=1 move to sheet 2 ... How would I go about this/

Name: rhawk7938
Date: April 2, 2007 at 18:01:16 Pacific

Reply:

Something like this: Sub MvColumn() If Range("E1") = 1 Then Columns("E:E").Select Selection.Cut Sheets("Sheet2").Select Columns("E:E").Select ActiveSheet.Paste End If End Sub

0

Name: DerbyDad03
Date: April 20, 2007 at 07:14:52 Pacific

Reply:

Sorry for the delayed reply, but... If you avoid "selecting" items in VBA before performing an action on them, your code will typically run faster and be easier to follow. For example, the code above can be condensed down to a single line. Sub MvColumn1() If Sheets("Sheet1").Range("E1") = 1 Then Columns("E:E").Cut Destination:=Sheets("Sheet2").Range("E1") End Sub

0

ben craddock 33

hiding Markup in word2003

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I am new to Excel macro and I need your help. I have the following input data in Sheet 1: a1 b1 (a1 in cell A1, b1 in B2) a2 b2 (a2 in cell A2, b2 in cell B2) I need a macro to create the following ...

Summary: Hi all, I'm trying to learn more about macros, so any help is appreciated. I frequently compile a multi-column list of things, then sequentially number the rows after I've made any additions. I've go...

Summary: Dear All, I would like to copy and paste my file(Any type) from one drive to another. For example: I have 10 files in c:\eliaz\Deal1 to d:\deals done using macro. Files may be of any type such as pdf,...