Search:

Cheers all, problem solved thanks very much.

Cheers for your quick reply. I'll give that a try - so if I can use my original example this would be:
if range("k") - range("j") < 0.6 then range("k").entirerow.delete

I havent given a cell...

Hi,
This is a VBA question - hope I have picked the right forum!
I am not an experienced VBA person, so please be gentle!!:)

I have a large excel sheet from which I need to delete certain rows, ...

Hi Passel, and others who kindly replied:
That was it - used write / input! Many thanks, and stay safe by not drinking disinfectant ;-)

Hi and thanks all.
Probably not necessary to show the calcs that led to homx etc., because they work (and the variables are all dim'd as double) and they are there, correct, in the text file....

Hi and thanks all.
Probably not necessary to show the calcs that led to homx etc., because they work (and the variables are all dim'd as double) and they are there, correct, in the text file....

OK, here we are. There are 2 forms (frmHomestar, frmStars in order of operation) and modCalculations.

(In declarations section of modCalculations)

Public Const PI = 3.1415926
Public hrs As...

OK, no I know I didn't do that, I am familiar with that particular issue. Get back to you super fellas soon...

Okay. I will do that tomorrow, as the coding is on another machine, which is in another room (and is off!) - thats why I had to make up a bit of dummy code. Thanks for your quick reply.

Hi,
Four numbers (dim'd as double,double,double,single respectively) are sent by one form to a sequential .txt file, which is then closed. Variables are dim'd in an external module, since they need...