Home Use a macro in a range reference
Reply: 0

Use a macro in a range reference

user453
1#
user453 Published in June 18, 2018, 3:35 am
bottom = Cells(Rows.Count, 1).End(xlUp).Row
Range("A2").FormulaR1C1 = "=countblank('[Test.xlsx]Sheet1 test'!C1:C1)"

I am trying to use the "bottom" value in my range !C1:C1). I want to be able to count the value of missing cells in a column. I tried several combinations but I couldn't find a way of making it work. For example if bottom is 10, I want it to count the missing values in column 1 up to row 10.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.548783 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO