-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
find header
-
Z
Convert Recorded Macro to Dynamic Values/Ranges
Hello, I've recorded a Macro that filters a column by color, and then sorts another column in ascending order. I'm trying to make this code more dynamic so I can reuse it elsewhere. I've been playing around with ways to find the active Sheet (ActiveSheet.Name )and active Table...- zero269
- Thread
- active sheet active table dynamic values find header macro vba
- Replies: 6
- Forum: Excel Questions
-
G
Find header row on the sheet and copy it
Hello, I need your help, actually i'm using this code to copy data (essentially data on table format vite headers and line of data). Sub Extract() ' Wrkb_Org for the file which is gonna be copied using msoFileDialogueFilePicker the base file ' Wrkb_Trs for the "Template.xlsm" file in...- Gwhaou
- Thread
- copy table find header msofiledialogfilepicker
- Replies: 5
- Forum: Excel Questions
-
M
Find Column Header "location" and then Insert a Column with Column Header "Radius"
Hi all, I'm just learning VBA, so I'm struggling with finding the column header "location" and then inserting a column to the right with a column header "radius." I would like to make this so that it loops through all of the worksheets in the workbook. 1-- Function loops through all...- mermaidGurl
- Thread
- column find header header insert column vba code successful
- Replies: 5
- Forum: Excel Questions
