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...
Already tried printing in 25 different colours, but it doesn´t work.
It seems very strange to me that, using other prorgrams, not excel, the printer prints in grayscale no problem. It seems to be a problem with excel itself.
thanks for the help anyway!
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
Sorry, the tags didn't seem to work????
I'm sending the code again, to make it easier to read.
Sub CopyData()
'Copies data from "Data" sheet, into "ConversionCosts" sheet
Dim ConversionRows As Integer
Dim DataRows As Integer
ConversionRows =...
Again, thanks for all the help!!
However, now its not working again in another part of the code. I'm sending it all over, hope you can help.
Sub CopyData()
'Copies data from "Data" sheet, into "ConversionCosts" sheet
Dim ConversionRows As Integer
Dim DataRows As Integer...
RobBroekhuis, thanks
The code is now working. I wasn't using the value returned by UsedRange.Rows.Count, but I was using a value from a loop I did, that just went through all the rows, until it found an empty one, assiging a 'counter' to it.
Although, like I said, my code is now working, why...
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.