sheet6

I created this macro by recording. I selected all sheets and the code shows 13 sheets. So I can only use this macro with 13 sheets. I would like to be able to use it for any amount of sheets. All help is much appreciated:) Sub FindDistance() ' ' FindDistance Macro ' ' Range("E1").Select...

Can I get suggestions for the additional code needed to remove the selected item from Sheet6? This only removes the item from the UserForm. Private Sub UserForm_Initialize() With Sheet6 ListBox1.List = .Range("A2", .Range("A" & .Rows.Count).End(xlUp)).Resize(, 2).Value End With End Sub...

sheet5 https://i.stack.imgur.com/nbBHL.jpg sheet6 sheet7

I have built a tool on a different sheet, and it basically fills out 5 rows and 3 columns of data. What the tool does doesn't really pertain to anything I need to do, but I'd like to have a way to send the data that I use with the tool to another sheet in the workbook. So data in C13:E17 is the...

I have seen many posts like similar to this but none seem to do what I need. I sure hope you can help. I would like to be able to populate sheet3 range I10 to I109 with alpha numeric values (never the same and may not have values for all 100 cells). Then have a macro that will search for an...

Hi all I'm using this line of code to activate a workbook sheet Worksheets(Worksheets("Front").Range("A1").Value).Activate So the 'value' found in cell ref A1 of the Front sheet will always be a number between 1 and 31 The workbook contains 31 sheets, named 1,2,3,4,5, etc etc thru to 31 I...