I am looking for VBA code which will select entire range in a row from active cell until last non empty blank cell.
To elaborate further, in first row the range of cell begins from D1 to AA1 (there are blank cells in this range). At any moment if I run the VBA code, from active cell until AA1, the selection should be copied for further process.
It's my sincere request to help me in providing the VBA code.
Thanks for your time & support in advance.