Hi. I'm struggling to write a code that will produce the result appears in the attached file. Recording macros brought me so far (not even close). Thanks:
Please Login or Register to view this content.
Hi. I'm struggling to write a code that will produce the result appears in the attached file. Recording macros brought me so far (not even close). Thanks:
Please Login or Register to view this content.
Hi, GIS2013,
maybe like this if you have just the raw data on the sheet:
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi HaHoBe,
Thanks, and two questions:
-If my real DataBase contains much more columns (and as a result I'll need much more new columns to insert)?
-How do I decode this: Range("C3:C" & Range("A" & Rows.Count).End(xlUp).Row)? It looks like a nested range object? could you simplify it a bit for me?
Hi, GIS2013,
I donŽknow about the requirements in the "real" Database but only about the sample posted here. If there are more columns and you need more single columns you could use
Here you would need to enter the ranges for the columns where you want to insert an empty column, these are inserted in one go whereas my code inserted them one at a time (and thus had different ranges indicated).Please Login or Register to view this content.
You need to know how far the formulas should go. I assumed Column A to be filled throughout and take the row number from there to fill the formulas. Please mind that you would to alter the formula ranges as well as they refer to the situation in the sample.Please Login or Register to view this content.
HTH,
Holger
All clear now, thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks