activecell.column

  1. S

    add found cell address to formula

    hi there, can someone pls help. I'm trying to add found cell address to a formula but can't get it to work my code so far Dim LL l = Application.Match("Delivery", Range("1:1"), 0) If IsError(l) Then On Error Resume Next End If Columns(l).Select LL = Cells(2, ActiveCell.Column) 'LL =...
  2. M

    How the get the column or row number of a changed cell on Worksheet_Change condition?

    Dear Gents, Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Range("B2:B5")) Is Nothing Then Cancel = True ActCol = Activecell.Column 'other macro According to above codes, If the user change the value of B2 to B5 and press "tab" on...
    • minmark
    • Thread
    • activecell.address activecell.column tab user worksheet change event
    • Replies: 5
    • Forum: Excel Questions
  3. A

    Creating VBA Macro that Selects certain words and then copies entire row into seperate sheet

    I am trying to create a macro that will look in a particular column (say column A) and search for certain text that I define (such as the word "one day") and if the cell has that words, the macro would slect that entire row and paste the row into a seperate spread sheet. I tried using...
  4. Y

    ActiveCell.EntireColumn.Select for Autofill

    I have some problems, thanks for helping me. Sub autoFill() Columns("BB:BB").Select Selection.autoFill Destination:=Columns("BB:BC"), Type:=xlFillDefault Columns("BB:BC").Select Range("BC4").Select End Sub I want to make Columns("BB:BC") as Dynamic using ActiveCell.Offset I...
  5. D

    Simple If statement

    Can anyone please tell me why the heck this does not work? If ActiveCell.Column <> 51 Or ActiveCell.Column <> 52 Then MsgBox "You can not edit this column.", vbCritical, "For your safety..." Else CODEact End If Thanks!

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top