Search results

Dear all, Can anyone help me with a VBA code to resize VBA form (in Excel) according to the screen size which may differ from PC to PC? Also I have one more requirement: I have designed a form in Excel and I don't want Excel to show up even in a minimized mode. I just want Form to appear...

Thanks a lot XLD. Its fine now.

Hi Hui, I need your help. I was visiting the website where shortcuts were mentioned. I was trying to do some of them in a new excel book. Suddenly, to my surprise the Column Headers which used to be in Alphabets A, B, C,... has now changed to 1,2,3,4,5.....16384. Meaning I have numbers in...

Hui, I tried something in a little round about way. Out of sheer eagerness to get a pat from you :-) Cell A1 holds the value 36800008 Below are Formula Cells Cell B1 =IFERROR(IF(LEFT(A1,1)="0","",(LEFT(A1,1)&(REPT("0",(LEN(A1)-1))))),"") Result in B1 - 30000000 Cell C1...

Hui, You are real excel magician. I got my result using your formula. Thanks a lot for your help. Regards, Ramnath

Hi, Please help me in converting a number in to the following format. Eg: 368002 Solution expected 300000 60000 8000 2 Eg: 300002 Solution expected 300000 2 Assumptions: - The sum of the broken down numbers should be equal to the original value - There won't be any decimals -...

Hi Chandoo, I have a peculiar problem. I want to show some data points which are for the previous months (not a part of the Current month’s Survey file) along with the current month Pivot table. I need to have Previous months data against respective Parameters in order to show the last month’s...

Thanks Hui. You are really helpful. Regards, Ramnath

Dear Hui, Thanks for your immediate response. Yes. Your assumption is right. There are 3 different columns occupying 7 rows. I am trying to automate some reconciliation and I have done almost 99% of it. Finally, I had this challenge of removing both positive & negative numbers which are...

Hi Chandoo, I have a problem in removing duplicates of Positive & negative signs in a same column. There will be only one positive & one negative with same amount. More than one in either of the positive & negatives are not possible. A sample of my worksheet goes like this... Cell Type...