LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel VBA syntax problem

I'm trying to learn a little macro writing here, I've got some experiec
with other programming languages, but don't know vba very well yet.

I'm probably making a very simple mistake.

All I want to do is select 4 rows, delete them, then skip one and mov
down.

Here is what I have so far, not sure where to go from here.

Dim counter As Integer

For counter = 1 To 2000
Rows(counter, counter + 3).Select
Selection.Delete Shift:=xlUp
Next counter
End Sub

Any help would be appreciated

--
Message posted from http://www.ExcelForum.com

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Syntax? MurrayBarn Excel Worksheet Functions 8 June 12th 09 01:45 PM
PLS HLP! Countifs Syntax Problem? dee Excel Worksheet Functions 5 June 14th 07 10:14 AM
.XValues syntax problem JF_01 Charts and Charting in Excel 1 December 19th 05 08:21 PM
Syntax problem Alex H Excel Worksheet Functions 1 July 2nd 05 08:23 AM
Another Syntax Problem Sharlene England Excel Programming 2 December 2nd 03 10:04 PM


All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"