Forum

SunnyKow
@sunnykow
Noble Member
Joined: Jun 25, 2016
Topics: 0 / Replies: 1417
Reply
RE: Run Time Error Method 'Value' of object 'Range' failed

Hi Irfan Try this. Hope it helps. Sunny

7 years ago
Forum
Reply
RE: Run Time Error Method 'Value' of object 'Range' failed

Hi Irfan I was unable to reproduce the error in Excel 2010 but it occurred in Excel 2013. No idea why a different version should trigger this er...

7 years ago
Forum
Reply
RE: If......While using Delete and Space key. how to??

I had use SUBSTITUTE to cater for all scenarios (I hope I got it all covered) Just in case there is a SPACE in front of a text in cell A1 eg. " Hel...

7 years ago
Reply
RE: If......While using Delete and Space key. how to??

Hi Forrest You have a good weekend too. Do let us know the outcome. Sunny

7 years ago
Reply
RE: macro for conditional format error

Hi Melinda Thanks for your compliments. Sunny

7 years ago
Forum
Reply
RE: Merge few cell of rows in separate column.

Hi Melinda Glad you liked it. Hope you will find a lot of use with it. Sunny

7 years ago
Forum
Reply
RE: If......While using Delete and Space key. how to??

Try this =IF(ISBLANK(A1),"Del Key",IF(LEN(SUBSTITUTE(A1," ",""))=0,"Space Key","")) It will show Del Key if A1 is deleted with the DELETE key ...

7 years ago
Reply
RE: VBA to copy all worksheets into one

Hi Amy Glad you like the macro. The code LastSrc = ws.Cells(Rows.Count, "B").End(xlUp).Row search for the last row with data in column B. You...

7 years ago
Forum
Reply
RE: If......While using Delete and Space key. how to??

Hi Forrest Try this =IF(AND(ISBLANK(A1)=FALSE,LEN(SUBSTITUTE(A1," ",""))=0),"Space Key","") Sunny

7 years ago
Reply
RE: VBA to copy all worksheets into one

Hi Amy Give this a try. Please note that for any additional sheet to be added and merged, the sheet's name must contain the text "Scrap Report" ...

7 years ago
Forum
Reply
RE: work out bonus for largest profit using if function

There is no attachment. You can try this. In cell K10 enter =IF(G10=MAX($G$10:$G$14),2000,0) copy till K14 Hope this helps. Sunny

7 years ago
Reply
RE: Calculating totals across multiple workbooks

Hi Andy That cannot be done as Excel will always recalculate whenever a cell value is changed. The best I can think of is to convert your formul...

7 years ago
Reply
RE: Rank for rows

Hi Ehab In cell C2 enter =IF(COUNTIFS($A$2:A2,A2)>5,"",COUNTIFS($A$2:A2,A2)) Copy down as required. Hope this helps. Sunny

7 years ago
Reply
RE: Code & date fix But Time shift row to Column wise

Hi Frans Thanks for your compliments For the helper to work, the data need to be sorted in the correct sequence. This will allow the headers...

7 years ago
Reply
RE: Calculating totals across multiple workbooks

Hi Andy I don't quite understand your requirement. Are you saying if you have already used a rate (say column E of the Employee database) for sh...

7 years ago
Page 37 / 95