Hey everyone,
Not sure if this is a complicated problem or not but it is well out of my reach. I have a spreadsheet with data in the first two rows A-H. There may also be more data though in columns D&E. I want to put some code into my VBA form which will check what is the last row with data in it (columns D&E), select cells in column A (from A2 down to that row with data) and merge cells. Its just some further formatting whihc I would like to add to tidy things up but its proving a bit tricky for me. Any ideas
Thanks guys
Not sure if this is a complicated problem or not but it is well out of my reach. I have a spreadsheet with data in the first two rows A-H. There may also be more data though in columns D&E. I want to put some code into my VBA form which will check what is the last row with data in it (columns D&E), select cells in column A (from A2 down to that row with data) and merge cells. Its just some further formatting whihc I would like to add to tidy things up but its proving a bit tricky for me. Any ideas
Thanks guys