selecting columns

Good day to you. I'm trying to revamp a bit of VBA code based on unknown column locations, known only by their header names. :cool:This first bit of code is working properly as it should: Private Sub STEP4_Separate_Name() ' '''''''''''''''''''''''''''''''''''''''''''''Insert 4 columns to...

Hi, Good evening all, I am facing problem in selecting certain no of columns. Say, I am in A1 and want to select 256 columns in the first row, just to input some values. Since I do not know the 256th column name (the alphabet which represents the Column name), I could not select it instantly...

Hi, I am having an issue with providing the correct syntax to select a column in my source worksheet and then copy and paste this column into my target worksheet. My Workbook (executing the code) we'll call MainBook. The Source Workbook is SourceBook (XferArray(1)). The Source Sheet is...

Hi, I have a load of data stored in an array and have written something (or cut and paste cobbled together more accurately) that locates a particular name at the top of a column within that array. What I want to do is then select all the contents of that column and paste it into a worksheet...

Good morning, I have an excel sheet with data in 4 columns, i am want to create a macro that delete the first column, i m using this code: Columns("A:A").Select Selection.Delete Shift:=xlToLeft there is some merged cell (A:D), so the macro select the 4 columns. I learned this code...

Hi, I am a complete beginner to excel VBA and macros. I have an excel spreadsheet which I want to use like a daily meal planner based on nutritional requirements. The first column is the names of nutrients found in food such as calcium, vitamin A, protein, etc. Each following column's first...