Personal Macro Workbook
It would save me much time if my VBA macros were available to all of my Zoho Sheet workbooks. I could not find a way to create an equivalent to Excel's Personal Macro Workbook. Having the capability to establish a reference in the VBA Editor to another workbook -- making that workbook's macros available -- would be an ideal solution to the problem.
Separately, many hours were lost yesterday when I tried to use VBA to take cell values [X = range().value] and use them in an equation [Y = 2* X]. (X and Y were dim Single). The VBA equation would work if the cell contained a number [4], but not if the cell contained an equation [=2+2]. I later deduced that currency-formatted cells with equations are seen in VBA as strings beginning with a "$."
I had to write a VBA function to strip the "$" from these numeric entries to use them mathematically. This IMHO should not have been necessary.
Oh, yeah. One more thing. I know the Freeze Pane capability is new, but some instructions on Freezing row and columns simultaneously would be helpful.
Separately, many hours were lost yesterday when I tried to use VBA to take cell values [X = range().value] and use them in an equation [Y = 2* X]. (X and Y were dim Single). The VBA equation would work if the cell contained a number [4], but not if the cell contained an equation [=2+2]. I later deduced that currency-formatted cells with equations are seen in VBA as strings beginning with a "$."
I had to write a VBA function to strip the "$" from these numeric entries to use them mathematically. This IMHO should not have been necessary.
Oh, yeah. One more thing. I know the Freeze Pane capability is new, but some instructions on Freezing row and columns simultaneously would be helpful.
Sticky Posts
Slicers are now available in Zoho Sheet—filter your data interactively
At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,Check out the new Checkbox in Zoho Sheet
Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the FormatFormat and analyze spreadsheet data with Zoho Sheet's Table
While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,Introducing Data Bars: Graphically represent changes in data within the cells
Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient methodZia in Zoho Sheet now makes suggestions on conditional formats, picklists, and checkboxes
Zia, Zoho's popular AI assistant, has been helping users succeed across Zoho applications since inception. In Zoho Sheet, Zia helps users efficiently build reports and analyze data with recommendations about data cleaning, charts, and pivot table. Also,