devs "hate" excel because you have to reference by col/row (C10 = tax rate, etc)... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		viggity on Jan 25, 2023 \| parent \| context \| favorite \| on: Show HN: I've built a C# IDE, Runtime, and AppStor... devs "hate" excel because you have to reference by col/row (C10 = tax rate, etc). But few devs know that you can name cells (and ranges and tables). Just to the left of the formula bar you'll see a textbox with the default name of the cell (C10). Just delete C10 and call it "tax_rate" and now you can reference "tax_rate" in all your formulas.

major505 on Jan 27, 2023 [–]

I did a lot of shit in excell using vb. Even spreadsheets connected to SAP using COM+ dlls.

But still sucks having to do requests in VB.

Consider applying for YC's Winter 2026 batch! Applications are open till Nov 10
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact