1.select

This code from the Excel Macro Recorder works, and does what I need, but it is not efficient. Can someone please help me and make it more efficient? Thank you in advance for your assistance! Robert Sub Macro1() ' ' Macro1 Macro 'Round 1 Topic 1 Question $100 ' ' Sheets("Setup Page").Select...

I am trying to loop the long code below until ... ActiveCell.Offset(1, -11) = "" If I cannot loop the code using the condition then looping the code for a specified number of times will suffice ... I am a novice with VBA so forgive me if I am going at this wrong to begin with but my desired...

Hello Everyone, First of all, I have to say, this forum has helped me immensely and I am so thankful for all the help offered here! I have not been able to find a solution to this despite the extensive research I have attempted. I have a VBA code that will prevent the user from modifying any...

i am a biginner of vba i need help in coding i trying to get filter data in same sheet please find the attachment below for further verification Private Sub CommandButton1_Click() a = Worksheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row For i = 2 To a If Worksheets("sheet1").Cells(i...

Private Sub CommandButton1_Click() a = Worksheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row For i = 2 To a If Worksheets("sheet1").Cells(i, 6).Value = "x" Then Worksheets("Sheet1").Rows(i).Copy Worksheets("Sheet1").Cells.field = 10 b = Worksheets("sheet1").Cells(Rows.Count...

Good Afternoon Excel Gurus, Need your help with a macro please. I have managed to achieve partially what I need, but what I am after is to repeat the same steps for a range selected in a row. A better option would be to give a popup to fill the adjacent cells (60 or 100 cells) or a range...

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 Mr. Excel Forum members, I need you help and advice. The code below works fine but I wanted to get away from hard coding the column / row numbers and use the Table header names instead. Any help would be greatly appreciated. -Don If rNumber_of_Rows = Number_of_Rows Then...