activecell.offset1

Dear Folks, I am trying to select specific columns from the filtered data but it select the all the columns. Can anyone help with the changes in my code. In my below code, it selects from A to P but I want to select A to N only. Please anyone can help where I can make changes into my code...

Hi all, Sorry to bother people with this, but I cannot seem to find what keeps crashing Excel in the following code. I already know the code is horrendous to look at as i'm not amazing at this, so if anyone could provide tips on keeping it efficient that would be awesome too. Private Sub...

Is there a way to offeset the cell selection without using .select? I have a macro that requires a lot of cell offsetting as it runs, but the .select commands are slowing things down to much. I've read a lot about ways to remove .select, but with all the copying and pasting this macro does I...

Hi, Need your help and assistance on the debugging issue I encountered. I've been using a code that runs smoothly when generating the Macro. But when I run the program again using another data, debug issue occurs. I've run series of data combination with one sheet and some run smoothly, but...

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