Search:

Type: Posts; User: lenze; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.37 seconds.

  1. Replies
    4
    Views
    295

    Re: Tell me what i am trying to do. Please.

    There is a reason Excel gives you so many more rows than columns!!!
    65,000+ vs 216 in Excel 2003 1,000,000+ vs 16,000 in Excel 2007.
    The reason is to accommodate data such as yours. You can write...
  2. Replies
    4
    Views
    295

    Re: Tell me what i am trying to do. Please.

    Yes, it's possible, but why would you want to? Your current layout is much more conducive to data analysis than the one you propose!! You can use a Pivot Table, Defunctions, and numerous other tools...
  3. Thread: if or statement

    by lenze
    Replies
    2
    Views
    232

    Re: if or statement

    Don't make this difficult!!

    IF(C3+C4<90,"YES",IF(C3+C4<100,"NEARING","NO"))

    lenze
  4. Thread: Check Box Macro

    by lenze
    Replies
    14
    Views
    601

    Re: Check Box Macro

    If Target.Column <> 1 Then Exit Sub
    will limit the macro to Column "A" only
    That said, you can only have ONE BeforeDoubleClick event. So you will need to use Select Case


    Select Case...
  5. Replies
    6
    Views
    292

    Re: Run Code Every Other Cell

    Untested, but try

    Dim Choices as Range
    Set Choices = Range("NamedRange")

    lenze
  6. Replies
    6
    Views
    292

    Re: Run Code Every Other Cell

    something like this??

    Sub DropDownCode()
    Dim Choices As String
    Choices = "Choice 1, Choice 2, Choice 3"
    For i = 12 To Rows.Count Step 4
    With Sheets("Sheet1").Cells(i, "D").Validation
    ...
  7. Thread: Check Box Macro

    by lenze
    Replies
    14
    Views
    601

    Re: Check Box Macro

    Have a look at xlAutoFit

    lenze
  8. Thread: Check Box Macro

    by lenze
    Replies
    14
    Views
    601

    Re: Check Box Macro

    The code in post #4 does that!!!
    Here is another way![code]
    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Cancel = True
    If Cells(Target.Row,"A") <> "Note" Then...
  9. Thread: Check Box Macro

    by lenze
    Replies
    14
    Views
    601

    Re: Check Box Macro

    I think my second code does that!! But maybe you want something like this??


    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Cancel = True
    Select Case...
  10. Thread: Check Box Macro

    by lenze
    Replies
    14
    Views
    601

    Re: Check Box Macro

    Maybe I'm confused!!
    The code I wrote works like this!!
    1) When any cell is DoubleClicked, It checks Column "A" in that row for an entry.
    2) If Column "A" in that row is Not blank, then it checks...
  11. Replies
    4
    Views
    486

    Re: copy column if previous column = A

    Sub CopyA()
    Dim cl As Range
    For Each cl In Sheet1.Range("C1:C7")
    LR = Sheet2.Cells(Rows.Count, "G").End(xlUp).Row
    If cl = "A" Then Sheet1.Cells(cl.Row, "E").Copy Sheet2.Cells(LR + 1, "G")
    Next...
  12. Thread: Check Box Macro

    by lenze
    Replies
    14
    Views
    601

    Re: Check Box Macro

    Do you mean something like this???



    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Cancel = True
    If Cells(Target.Row,"A") <> "" Then
    If...
  13. Replies
    1
    Views
    284

    Re: Use Macro on cell text and loop

    Hi and welcome to the board!!!
    Maybe this will help!!


    Sub CallMe()
    For i = 1 To Rows.Count Step 17
    Select Case Cells(i, "D")
    Case "MX2": Call MK2
    Case "MX3": Call MK3
    Case...
  14. Replies
    4
    Views
    486

    Re: copy column if previous column = A

    Perhaps like this??

    Sub CopyA()
    Dim cl As Range
    For Each cl In Sheet1.Range("C1:C7")
    If cl = "A" Then Cells(cl.Row, "E").Copy Sheet2.Cells(cl.Row + 2, "G")
    Next cl
    End Sub

    Note there...
  15. Thread: Check Box Macro

    by lenze
    Replies
    14
    Views
    601

    Re: Check Box Macro

    Why not dump the checkboxes for a Doubleclick??

    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Cancel = True
    Select Case Target.Row
    Case 10, 12
    If...
  16. Thread: RangeEnd

    by lenze
    Replies
    3
    Views
    240

    Re: RangeEnd

    Maybe

    Worksheets("Advanced filter").Range("A1").CurrentRegion

    lenze
  17. Re: Code to move to cell A after data entered into cell E?

    In the Worksheet module

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Count > 1 Then Exit Sub
    If Target.Column <> 5 Then Exit Sub
    Cells(Target.Row + 1, 1).Select
    End Sub
    ...
  18. Replies
    4
    Views
    496

    Re: Heinously difficult excel problem :-(

    HAve a look at Dynamic Named Ranges

    lenze
  19. Replies
    4
    Views
    293

    Re: Count how many columns in a worksheet

    LC = Cells(1,1).End(xlToLeft).Column

    lenze
  20. Replies
    3
    Views
    238

    Re: Multiple ranges in same argument

    With Union (Range("A44:E44"),Range("A47:A50")).Interior

    lenze
  21. Replies
    3
    Views
    238

    Re: Multiple ranges in same argument

    With Union(rng1,rng2,etc).Interior
    .Pattern = xlSolid
    .PatternColorIndex = xlAutomatic
    .ThemeColor = xlThemeColorDark1
    .TintAndShade = -0.249977111117893
    .PatternTintAndShade...
  22. Replies
    11
    Views
    733

    Re: Change cell value with button

    You could use a Spinner!!!
    lenze
  23. Thread: delete rows

    by lenze
    Replies
    3
    Views
    236

    Re: delete rows

    Try this

    If Not Isdate(Cells(i,"C")) Then Rows(i).EntireRow.Delete

    lenze
  24. Replies
    11
    Views
    783

    Re: Multiple greater thans

    Hi and welcome to the board
    You can use SUMPRODUCT. For your "y" model, per your example, you would use

    =SUMPRODUCT(--(B2:B16="y")*--(C2:C16>10))

    You could also use COUNTIFS in Excel 2007
    ...
  25. Re: Changing date in excel tab hampering my macro. Can i use partial name?

    Hi and welcome to the board!!!!
    Have you considered using the Code or Index Name in your macro as opposed to the Assigned Name? See my discussion here...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4