activecell

  1. F

    Exporting data to a new xls workbook

    Hi, I am trying to export data from an xlsm to a new xls. But the problem is that it only copies the first row and I need a table to be copied. My macro is this one: Sub ExportarTXT() Worksheets("Import").Activate If Sheets("Import").Activate Then Range("A1").Select If...
  2. B

    Referencing to a cell

    Hi, I have the formula below. How do I reference selection.name to a cell. Thanks! Sub Shoot() Dim r As Range Window_Capture_VBA Selection.Name = ActiveCell ExportPicture ActiveCell End Sub
  3. A

    Range Selecting With Activecell

    Hi folks, Thank you for my previous problem. I have small problem for selecting total column form Active cell I writ blow Code but it working I get this error "Run time error '1004' My Code Range("ActiveCell", Range("ActiveCell" & Rows.Count)).End(xlDown).Copy Please help me
  4. V

    IF THEN LOOP with ActiveCell

    Hello, I am trying to use an If Then Loop, but I cannot seem to get it to function properly Final Product: Excel will look at Column AN and if the cell value is True, then it will select the entire row and color it orange. Then it will go down to the next cell and check, until it reaches a blank...
  5. P

    Difference between 3 codes to see if cell is empty

    Hi There This is a very easy question to answer. I really get confused about the following 3 lines of code. I have used all three but I still do not know what the difference is. Here they are: 1. If ActiveCell = "" Then Code goes here Loop Until ActiveCell = "" 2. If...
  6. N

    Simple VBA

    Have a first and last name in cell C10. Recorded a macro to use TextToColumns. Selection.TextToColumns Destination:=Range("C10"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True, _ Semicolon:=False, Comma:=False, Space:=True...
  7. N

    Check if a cell is outside a range with active filter

    Hi! I am using a macro, which filters data in a column of activecell. ActiveCell.CurrentRegion.AutoFilter Field:=ActiveCell.Column - ActiveCell.CurrentRegion.Cells(1, 1).Column + 1, Criteria1:=ActiveCell.Value Assume you have two or more data ranges (tables) on one sheet, while one of that...
  8. T

    Loop qnd improvement needed

    Hi guys, I read this forum since a few months but this is my first post. Indeed, I need your help for the second macro of my life :) I am a financial auditor and I would like to create a macro that found the last coupon date of a bond, based on the maturity date, and before a certain date...
  9. C

    detect when a data validation drop down has been changed

    How do i detect when a data valiadation drop down selected and changed has been changed. Do I use activecell or target?
  10. A

    How to count columns based in the active cell

    Hi guys, I have a particular problem where I need to count always columns based in the raw after the active cell and return the result for an specific cell. For example, here below I need to count from column 1 to column 3, having as active cell column 1, raw 1. So as the active cell is in...
  11. R

    Else without If Error

    Hi, I'm getting an "Else without If" Error message from the following code. The last Else is where the error points to. I have 2 If's, 2 Elses, and 2 EndIf's, so I can't figure out what the error is. Can you please help? Sub Assign_Zero_Or_One() Dim r As Integer Dim n As Integer r = -1 n =...
  12. B

    Help to automate Text to Columns VBA

    Hello Excel World, Can someone help with some VBA lines to automate this "Text to Columns" process; https://support.office.com/en-gb/article/convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4477-a171-c5bad0f0a885 I've tried to edit a recorded step because the column I want to convert is...
  13. H

    Find and activate

    hi want to find and activate cell. Get syntax error dim t as String Worksheets("Sheet1").Activate Range("A1"). Select t = ActiveCell Columns("D:D").Select Selection.Find(What:=t. Activate help!
  14. S

    Dynamic Range Creation using ActiveCell - Possible?

    Hi all. I can think of at least two other ways to do this. I can sort the columns so I know the column number I can find the cell, select the column, create a named range and sort on that. And I'm sure there are many more. I'm curious why I've never seen a range starting with ActiveCell and...
  15. A

    Looping through sheets excluding sheet name isn't working

    Hello, I have the code below which is supposed to loop through all sheets in the workbook except for the one labeled CONSOLIDATED DATA or (Sheet1). It then does a reverse find on column A looking in reverse order for labels that form a table towards the bottom of the data. Once it finds the...
  16. P

    Input Box Trouble

    Greetings, This is my first attempt at using the Input Box Method. I have this piece of code that strips away extraneous characters and leaves just the serial number: Option Explicit Sub Extract_Count() Application.ScreenUpdating = False 'Change Column Headings...
  17. G

    Active Cell Issues

    I am building an application form in excel, whereas the applicant will only be able to edit unprotected cells. I have included coding so that the number of applicants, number of facilities, and number of collateral accounts can be populated to the correct spacing in the form. For example, I...
  18. V

    Need Help With VBA to Copy Active Cell Address to Range Variable

    This is my first post, but I have used code samples from this site for many years. My trust in the code I have "borrowed" has encouraged me to become a member and learn to create my own code. Many thanks to all! Excel 2010, MS Windows 7 Pro. I want to copy the address of the active cell to...
  19. N

    VBA Syntax

    Range("E2, G2").Select (This is what I want to do, but without specific cell addresses) Range (ActiveCell), Range(ActiveCell).Offset(0, 3).Select What syntax can I use to do this? (hope this makes sense!)
  20. T

    Macro to drag formula from activecell to last column used

    I am struggling to figure out a macro that will copy my formula on wherever my activecell lands on and drag that formula to the last column of my worksheet. For example, if my activecell with the formula "1" happens to land on cell b6, I was wondering if there is a VBA code out there that...

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