activecell

I am stuck on figuring out on how to fill down my formulas from the activecell selection to the last row used in column AK. Please keep in mind that the active cell can always be in a different spot of the excel spreadsheet. Dim LRw As Long ActiveCell.Select ActiveCell.Formula = "1" LRw =...

Hi, Below is my code, is there anyone who can help optimize this? Sub filtering() ' ' filtering Macro ' Dim Rng1 As Range, Rng2 As Range Dim ws1 As Worksheet, ws2 As Worksheet, ws3 As Worksheet Dim src As Range Set ws1 = ThisWorkbook.Sheets("eodcpos") Set ws2 =...

Hi there! Hoping someone can help me out! I have written up the below piece of code, which will check if the column directly above the selected Cell in Column A is empty or not, and if it is empty the macro will find the next available cell and make it the ActiveCell - thereby guiding the user...

I have the following code - (some sensitive information replaced by the word info) which works fine when each subtotal group has several entries, but falls over when there is only one entry. Could someone please help me out. The part of the code where is it specially giving me the 1004 error...

Context: I work inventory at a rebar fab company. I have this report that uses a userform to make tables that show the loads the mill has ready to be picked up. Then this compares these to what we have ordered for the specific cycle (to make sure we get everything we ordered). Now I am...

Hi, I have been using the code below, has been working ok but now I have more data so it takes considerably longer to run through. Code loops down column B and if cell on same row in column A = 0 then deletes zero Is there a more efficient way of doing this ? thanks Steve Range("B5").Select...

Hey Guys - This VBA code works, but just wondering if there is a better way to write it. PURPOSE/GOAL: User can add additional time to a day on a timesheet. Example: Employee works two shifts. Timesheet has In/Out/In/Out columns (4) so when they clock in more than 2x, we have to insert an...

Hello, I'm hoping that you could help me a little; I'm trying to copy the data from one worksheet(sheet2) to another (sheet1) using ActiveCell.Offset. I've done some searching and not really found anything helpful other than actually using something like; Range(“B2”).Select...

Hi all I am trying to write a code that selects a number of cells around the active cell depending on the value of cells A500 and C500 and then draws a boarder around them. So far i have the following but I need to change the ActiveCell(6,6) so it uses the values in A500 and C500 instead of 6...

Hi, I'm following this post to create an interactive calendar: http://chandoo.org/wp/2013/04/09/how...ents-tutorial/ The issue that I'm facing is steps 4 and 5 - I'm not able to get the macro to work. I followed the instructions for steps 4 and 5, but when I click on a calendar date, the date...

Can anyone help, I keep getting an error. Run-time error '13': Type mismatch when I debug it highlights the below line; 'ActiveCell.Offset(0, -1).Value = ActiveCell.Offset(-1, -1).Value + 1' Worksheets("report").Activate Range("d5").Select Do Until ActiveCell.Value = "" If ActiveCell.Value...

I feel embarrassed about posting this one, but I'm at my wit's end. Here's my code: Public Sub setactivecell() Worksheets("Sheet1").Activate Worksheets("Sheet1").Range("F1:H4").Select Worksheets("Sheet1").Range("G3").Select MsgBox (activecell.address) End Sub This is the only...

Ok, I'm back at it with another copy and paste question. In this sub I have a cell I click on(customer name) and it begins copy and pasting information from one sheet to another. However I'm not even able to compile this code. I have a feeling the ActiveCell is causing the problem. Any ideas...

I have a sheet1 with sets of grouped (hidden with + box or visible with the - box) columns. Each group of hidden columns is a Named Range. On sheet2 I have cells/formulas linking to the grouped/hidden columns/cells on Sheet1. When I jump (doubleclick or Ctrl-G) from Sheet2 to a specific...

Hi there, I would like to ask for help on how to resize based on the active cell location. I need the macro to copy the last 20 rows (Jan) of my existing data to generate the same formulas for the next Month. This is the code I recorded/edited. Range("A2").Select...

I'm trying to write a macro to pull up a webpage with a tracking number, return the delivered date, then move to the next tracking code to do the same. I want that to continue down the spreadsheet until there are no more tracking numbers. This can't start at a particular cell every time because...

After many hours it is time to ask for help! I have a blank sheet which I paste extracted data to with VBA. Columns A:E are static but the rows vary. The code loops and pastes data set at 5 rows from previous data until end. So I have blocks of data with space of 5 rows inbetween. I want to...

Hi, This is my first post, I hope someone can help. I have three columns of data and need to concat column 2 and 3 into column 4. Data Example: _ A B C D E F G 1 a a a 2 a a a 3 a a a 4 a a 5 a a 6 a a 7 a 8 a Where B and C are both present, I need them both to appear in D. Where B is...

I'm trying to get a cell in a VBA code to reference the value in column J (in the same row as ActiveCell) and multiply it by another value. I currently have used "= RC[-30] * RC[-39]" for the cell value to be input, but I have to do this for a number of different cells. The RC[-30] part will...

Hi VBA ninjas! Is it possible to run a loop based on this? If Activecell = Last Day of Month 1. Excel 2010; Windows 7 Pro 2. PC