the following macro which i got from someone very helpful Mr. jindong in this forum is allowing me to extract data that come in form of lotus version and turn it to VBA version , this macro working very good , but now i have some problems which hope to get some help ,
1. every time when the value is "0" it doesn't execute the macro. (look on sheet 1) it happens only if i put apostrophe before the "0"(i.e "'0") my question is........... what i need to change or to add in the module 1 (sub test_3) to make it work ???
2. row 12 (yellow highlight) {EDIT-CLEAR B:D1810..B:H1810;"CONTENTS"} it read: Range("D1810:H1810").ClearContents , but it should be sheets("sheet B").Range("D1810:H1810").ClearContents...............what need to add in the macro to make it work ???
3. row 251 (orange highlight),{EDIT-COPY B:F9}, it should be sheets("sheet B").range("F9").copy.......... what need to add in the macro to make it work ????
4.row 252 (blue highlight),{SELECT B:J73..B:J84}, it should be sheets("sheet B").Range("J73:J84").Select...............what need to add in the macro to make it work ??????
5. row 253 (gray highlight),{EDIT-PASTE}, should be Past of the value of B:F9 (point3) ...............what need to add in the macro to make it work
6. row 272 column B (green highlight),{CELL-ENTER "(+I:F651/3)"} should be Sheets("sheet I").Range("F651"/3) (i.e it should be divided by 3)...............what need to add in the macro to make it work ???
i wanted to attached my worksheet so it will more explanatory but i could not see how to do that , i don't have the attached file option
thank you in advance for all your collaboration it should save me ton of time if i can make it work , just not so so good in VBA to that level to correct my macros
Bookmarks