Dashboard


Recently changed pages


Insert Cells 
Last Edited By: jose.galindo.lucas  ( 23 - hours ago )

Apply Background Color 
Last Edited By: rameshs  ( 50 - days ago )

Find and Replace 
Last Edited By: aajasmine  ( 137 - days ago )

Copy Sheet Data 
Last Edited By: ajasmine  ( 166 - days ago )

Mail Notification 
Last Edited By: ajasmine  ( 365 - days ago )

Track Editing Time 
Last Edited By: ajasmine  ( 408 - days ago )

Trim Words 
Last Edited By: ajasmine  ( 408 - days ago )

MYSQ 
Last Edited By: rameshs  ( 438 - days ago )

Sample Macros 
Last Edited By: gjayakrishnan  ( 556 - days ago )

Unit Conversion 
Last Edited By: zohosheet  ( 557 - days ago )

more >>

Recently Attached Files


vbmacros_1257512894603.png [view]
Uploaded by : jose.galindo.lucas (23 - hours ago )

macroswiki.css
Uploaded by : zohosheet (557 - days ago )

search.gif [view]
Uploaded by : zohosheet (557 - days ago )

plus.gif [view]
Uploaded by : zohosheet (557 - days ago )

new_window.gif [view]
Uploaded by : zohosheet (557 - days ago )

more >>

Newly added pages  


Apply Background Color
rameshs  ( 50 - days ago )
Insert Cells
aajasmine  ( 137 - days ago )
Copy Sheet Data
ajasmine  ( 166 - days ago )
Track Editing Time
ajasmine  ( 408 - days ago )
Trim Words
ajasmine  ( 408 - days ago )


Recent comments


@kdinesh: we have added support for buttons. Kindly check http://blogs.zoho.com/sheet/new-in-zoho-sheet-insert-buttons-xlsx-support-time-zone-preference
Commented By: zohosheet  (50 - days ago ), Page: Welcome

Please support custom functions. Scientists and engineers need a Zoho Sheet program to calculate many types of custom functions, frequently repetitive. Please put it at the top of your list as we really don't need many of the features used in business!!! Otherwise, there is only Excel, which although lacking in so many ways, is still highly useful in engineering education. Thanks!
Commented By: smithscf  (120 - days ago ), Page: Welcome

Currently we are not supporting custom function in Zoho Sheet. We will look to support this in future.
Commented By: ajasmine  (200 - days ago ), Page: Welcome

As Microsoft points out, Microsoft can't "anticipate every calculation need of every user", nor can Zoho. Therefore, Microsoft provides, and Zoho should too, "the ability to create custom functions".

I can create the custom function in a macro module, as I can in Excel, but you don't seem to want me to execute it. I get an "#Invalid Formula!" error message displayed in the cell.

This is a HUGE, crippling omission, a major error!

-----------------------------------------------------------

Create your own worksheet functions

Although Microsoft Office Excel 2007 includes a multitude of built-in worksheet functions, chances are it doesn’t have a function for every type of calculation you perform. The designers of Excel couldn’t possibly anticipate every calculation need of every user. So instead, Excel 2007 provides you with the ability to create custom functions, which are explained in this article.

http://office.microsoft.com/en-us/excel/HA102189961033.aspx
Commented By: cobyzoho  (208 - days ago ), Page: Welcome

Yes, You can create functions and you can call that function in any procedure or other functions. You can't call that function directly from a cell as Excel functions.
Commented By: ajasmine  (248 - days ago ), Page: Welcome

Is it possible to create functions as with EXCEl VBA?
Commented By: walter_ochynski  (252 - days ago ), Page: Welcome

Can I create a Hyperlink in Sheet1 which will take me to Sheet2?
Commented By: kdinesh  (356 - days ago ), Page: Welcome

Is it possible to create buttons which run the macros, rather than going to the macros menu?
Commented By: kdinesh  (356 - days ago ), Page: Welcome

Select the sheet name(e.g.Sheet1) from the left panel of the macro editor and copy the above code and paste it into the editor. Save the code and close the editor. Now change the cells in the Sheet1 where you pasted the code, you can see the current time is set to the first column of that changed row.
Commented By: ajasmine  (389 - days ago ), Page: Track Editing Time

I have just copied the code into macro editor (This workbook).
Unfortunatelly, nothing happens changing any cells in my sheets.. :-(
P
Commented By: pvojnisek  (389 - days ago ), Page: Track Editing Time

This macro cannot be applicable for format related replacement.
For example Currency format changes, '$' symbol was replaced by 'USD'.
It was possible by using " Selection.cells(i, j).Text " tag.
Commented By: sasi  (477 - days ago ), Page: Find and Replace

more>>