VB question, please help...

Feb 26th, 2002, 02:21 PM

How do you select a range , say b1:g1, & copy & paste it (and the formulas) to into b2:g2.

gplhl · Feb 26th, 2002, 02:27 PM

Quote:

On 2002-02-26 13:21, Anonymous wrote:
How do you select a range , say b1:g1, & copy & paste it (and the formulas) to into b2:g2.

sub copydata()

Range("B1:G1").Select
Selection.Copy
Range("B2").Select
ActiveSheet.Paste
End Sub

Feb 26th, 2002, 04:11 PM

Quote:

On 2002-02-26 13:21, Anonymous wrote:
How do you select a range , say b1:g1, & copy & paste it (and the formulas) to into b2:g2.

You can get the code to do this by using the macro recorder.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 02:21 PM	#1
Guest Posts: n/a	How do you select a range , say b1:g1, & copy & paste it (and the formulas) to into b2:g2.