with statemet

  1. F

    With...

    Hi, I want to delete one column. Generaly It could be done like: Columns("AY:AY").Select Selection.Delete Shift:=xlToLeft But how to do it in "With...." With sourceWb.Sheets("Sheet1") .Range("A1:B6").EntireRow.Delete LastRow = .Range("CW65536").End(xlUp).Row '....delete...
  2. N

    Going Loopy

    Hi all, struggling with concept of looping so could really do with your help My problem is this In one workbook I have a list (indeterminate number) of values which have been data sorted to group duplicates together. Eg JC000 JC001 JC001 JC001 JC002 JC002 In another workbook I hold a full...
  3. D

    VBA & Macros Book Code Sample Yields Error

    I'm using code from the VBA & Macros for Excel 2007 book and pg 255 to populate a userform using an advanced filter to get a unique list. The code hangs up at the line: "With.Me.lbCust". I'm getting an error "Message or Data Member not found". What am I missing?

Some videos you may like

This Week's Hot Topics

Top