Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Jun 11, 2026
Topics: 61 / Replies: 1588
Reply
RE: Automatic fill required cells

If you want the value in E7 to be in F12:F62 then in F12:F62 you type =$E$7 Not sure what you mean by 'according required' but I think you might wa...

7 years ago
Reply
RE: Print layout problem

Hi Lea, You should be able to print the file on one page by adjusting the print settings or page setup, e.g. In your print dia...

7 years ago
Reply
RE: How to get newest file from folder

When you are writing your reply, there's a button below the box you are typing in marked 'Attachments'. Click on that and then on 'Add Files' and sel...

7 years ago
Forum
Reply
RE: Output a cell's information to a website

Hi Damon, I wouldn't use Excel for this. You'd be better off writing something in the languages supported by the CoinGecko API like NodeJS or Pytho...

7 years ago
Reply
RE: Can't find library or project error message

You may have a missing reference. In the VBA editor go to Tools->References and look through the list for anything marked MISSING. If you find ...

7 years ago
Forum
Reply
RE: Error scraping web data. Help with the VBA code

Hi Peter, Can you please supply the workbook with the data to be used in Step b, otherwise the form submission doesn't work. Please explain what...

7 years ago
Forum
Reply
RE: Pyramidion Cryptocurrency needs an API URL for reporting our price to exchanges from an Excel sheet's single cell.

Hi Damon, As Pyramidion isn't yet supported on CoinGecko this task can't be done. You could write some code to connect to the CoinGecko API and ...

7 years ago
Reply
RE: How do I program a stop and then resume with a macro?

Hi Aaron, There are a number of ways to make your code pause, check this Does this process have to be written in VBA? Could you use Python? ...

7 years ago
Forum
Reply
RE: If... then copy a cell

Hi Janine, You can learn to use the IF function with these posts In E2 you need =IF(B2=0,A2,"") and in G2 =IF(B2=0,$B$1,"") ...

7 years ago
Reply
RE: How to protect multiple sheet for different users

Hi Vic, I don't have any issues adding data to that workbook or adding/deleting columns. The issue seems to be specific to whatever setup you ha...

7 years ago
Reply
RE: How to protect multiple sheet for different users

Hi Vic, The VBA module in your workbook is password protected so I can't look at it. I never run VBA without checking it over first. Phil

7 years ago
Reply
RE: How to automatically generate invoices for selected rows

Hi, Can you please attach your workbook so we can see what you are working with. Regards Phil

7 years ago
Forum
Page 96 / 110
0