Hello,
I am trying to connect to a server, but it's on a line that has a greeting message when it answers, and wants you to hold on before starting the connection. My problem is that my modem does not recognize this message, and disconnects before it receives any tone.
Does anybody know how to...
I am using excel 2000, office 2000, and an HP Laserjet 400 printer. I am trying to print grey chracters, but they come out black. I´ve already tried modyfing many settings, but I can´t make my characters come out grey. I already checked, and I can print a grey box, for example, but not grey...
Anybody know why a cell in Excel will not want to format?? I have a spreadsheet with data I have imported from a database. The spreadheet is not protected, of course.
Either rightclick -> format cells, or Format -> Cells, just do not work, it doesn´t do anything!!
Help please, this seems like...
Does anybody know how to make VBA check for empty cells in excel??
I have a bit of code that searches recursively until it finds the first ocurrence of cell = Null or cell = "" and then assigns this rownumber to a variable.
When I refer to this variable r, the first time, it works...
Anybody know how to refer to a workbook, using a variable??
My procedure asks the user to input the name of the excel workbook to open, asigns this filename to a variable, and opens it. Then I need to call this opened workbook, from the original procedure, but I don´t know how to refer to it...
Does anybody know how to get a valid, full filepath from a user. i.e. Getting the user to browse through the 'SaveAs' dialog box, chose an appropiate file, and that the chosen file is returned as a full-filepath, not just a file name.
thanks
I have some code in VBA that looks for a file, and then opens it.
Does anybody know of a way to check if the file exists/filepath is valid, before trying to open the file, so as to not produce an error?
thanks
I am trying to write some code that will count the number of total rows in a particuar sheet, and then delete the data in them, but only for some of the columns.
The counting bit was easy just setting a variable equal to:
UsedRange.Rows.Count
However, when I try to reference a Range wichi...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.