vasanthsv84 Posted February 24, 2021 Share Posted February 24, 2021 Goodday Everyone, I have created a vba code for creating Longitudinal section (inputs from excel), also I want to make a gap between the profiles if a row was empty in excel. Can anyone guide me through this!? Thanks Regards, Vasanth. S Quote Link to comment Share on other sites More sharing options...
BIGAL Posted February 25, 2021 Share Posted February 25, 2021 You would use the cell is empty as a loop in a loop, if it was a csv file it would be read-line is "" Quote Link to comment Share on other sites More sharing options...
vasanthsv84 Posted February 25, 2021 Author Share Posted February 25, 2021 Hi Bigal thanks for the response, can you please share a sample vba code to find the empty cell in excel. Thanks Quote Link to comment Share on other sites More sharing options...
BIGAL Posted February 25, 2021 Share Posted February 25, 2021 Sorry I dont do much in VBA started to play with it but went back to lisp. Some else will help. Quote Link to comment Share on other sites More sharing options...
vasanthsv84 Posted February 26, 2021 Author Share Posted February 26, 2021 Hi Bigal, it's ok. I found a way around to it. Thanks for the suggestions. GPT = Rng.Cells(RowIndex, 10) Select Case GPT Case "1" InsPtsST(0) = 0: InsPtsST(1) = 0: InsPtsST(2) = 0 Case "2" InsPtsST(0) = 0: InsPtsST(1) = -500: InsPtsST(2) = 0 Case "3" InsPtsST(0) = 0: InsPtsST(1) = -1000: InsPtsST(2) = 0 Case "4" InsPtsST(0) = 0: InsPtsST(1) = -1500: InsPtsST(2) = 0 Case "5" InsPtsST(0) = 0: InsPtsST(1) = -2000: InsPtsST(2) = 0 Case "6" InsPtsST(0) = 0: InsPtsST(1) = -2500: InsPtsST(2) = 0 End Select Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.