LinkBack URL
About LinkBacks
Hi experts,
1- Open enclosed file.
2- Select "TestSheet".
3- Run Macro1.
4- Understand what Macro1 is doing. (Macro1 is needed improving)
5- My question is how I can convert "TestSheet" to "TargetSheet" ?
Best wishes.
Hi experts,
1- Open enclosed file.
2- Select "TestSheet".
3- Run Macro1.
4- Understand what Macro1 is doing. (Macro1 is needed improving)
5- My question is how I can convert "TestSheet" to "TargetSheet" ?
Best wishes.
Last edited by HerryMarkowitz; 01-06-2014 at 10:21 PM.
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
Solved... Sorry
Please Login or Register to view this content.
hi there again, Herry. what kind of improving you need? to not touch column A? basically, the macro is doing this (you can try in excel).
1. press CTRL + G -> Special -> Constants -> OK
2. any cell selected will be referred to the selected row 1 of that column
you could change point 1 slightly to just choose Numbers. you noticed in the GoTo Special Window, there are checkboxes you can deselect. so the code to choose just numbers is:
Please Login or Register to view this content.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks