sanket.katkar
New Member
Actually I want to select Row 12 - 28 of Column E, and then i have to perform Find and replace. In find i write the last row number of the previous sheet and replace with next row number of that sheet. So for Eg: if i have 2 worksheet name KPI and Email. I select the rows from email sheet anf perform find and replace option by ctrl+H and in find I write the last row number of KPI sheet and replace with the next row number of KPI sheet.
so can you suggest the code. as in macro i get the last row number of the KSI sheet which is stored in a variable.
so can you suggest the code. as in macro i get the last row number of the KSI sheet which is stored in a variable.