Whoops, forgot the attachment. On Mon, Mar 1, 2010 at 1:59 PM, Mark Kim <mark....@gmail.com> wrote:
> thanks.. > > um.. where is the code? ^ ^ > > On Tue, Mar 2, 2010 at 6:01 AM, Christopher Luka < > christopher.l...@gmail.com> wrote: > >> OK, I modified the code to leave the six rows prior to the FBT details >> line. Does this do what you want it to? >> >> >> On Sun, Feb 28, 2010 at 9:15 PM, Mark Kim <mark....@gmail.com> wrote: >> >>> Hi, Thanks for the code. >>> >>> But I tried but it doesn’t seem to work as expected. Can I ask you this >>> please? >>> >>> in the data sheet you uploaded, what I want is to select Dat1 to Data 7 >>> and remove blank rows. In my real data I work with, there are 6 rows between >>> the last transaction record and FBT details. And I’d like to keep that >>> distance. >>> >>> If you can write a code to select this range, I think I can use the >>> following code to remove the blank rows.. >>> >>> Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete >>> >>> Could you revise the code??? >>> >>> I really appreciate your help. >>> >>> >>> On Fri, Feb 26, 2010 at 7:33 PM, Christopher Luka < >>> christopher.l...@gmail.com> wrote: >>> >>>> See attached for example. >>>> >>>> >>>> On Thu, Feb 25, 2010 at 9:44 PM, Ayush <jainayus...@gmail.com> wrote: >>>> >>>>> Hi Markkim, >>>>> >>>>> Would you please send the sample file containing this data? >>>>> >>>>> Best regards, >>>>> Ayush Jain >>>>> >>>>> On Feb 26, 6:18 am, Markkim <mark....@gmail.com> wrote: >>>>> > Hi >>>>> > I have been trying to make these but have failed. ^ ^;; >>>>> > I’d like to create a macro >>>>> > >>>>> > A21 has a word called ‘Date’ >>>>> > >>>>> > And somewhere down in column A has a cell with a word ‘FBT Details’. >>>>> > The location of FBT details depends on the amount of data between >>>>> > these two headings. I’d like to remove any blank rows between A21 >>>>> and >>>>> > location of >>>>> > FBT details – 7. >>>>> > >>>>> > What I mean is >>>>> > >>>>> > For example, location of FBT details is A1207. Then I’d like to >>>>> > remove any empty rows (cells) between A21 and A1200 (not A1207). so 7 >>>>> > rows above. >>>>> > >>>>> > I’d like to do this because the data between these cells are one row >>>>> > apart. >>>>> > >>>>> > Could you help me please? >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> Some important links for excel users: >>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>> http://twitter.com/exceldailytip >>>>> 2. Join our Facebook Group @ >>>>> http://www.facebook.com/group.php?gid=287779555678 >>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>> >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>> HELP US GROW !! >>>>> >>>>> We reach over 6,800 subscribers worldwide and receive many nice notes >>>>> about the learning and support from the group.Let friends and co-workers >>>>> know they can subscribe to group at >>>>> http://groups.google.com/group/excel-macros/subscribe >>>>> >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our Facebook Group @ >>>> http://www.facebook.com/group.php?gid=287779555678 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> HELP US GROW !! >>>> >>>> We reach over 6,800 subscribers worldwide and receive many nice notes >>>> about the learning and support from the group.Let friends and co-workers >>>> know they can subscribe to group at >>>> http://groups.google.com/group/excel-macros/subscribe >>>> >>> >>> >> > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
ExcelMacros_DeleteBlanks.xlsm
Description: Binary data
