activecell

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...

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

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

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...

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...

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...

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...

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...

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

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...

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 =...

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...

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!

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...

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...

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...

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...

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...

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!)

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...