Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
BUT, I need a VBA code that resizes the Range based on data lines fra the data sheet.
Sub Makro1() ActiveSheet.ListObjects("Tabel99").Resize Range("$A$3:$D$14") End Sub
|Formula not working in excel =SUMPRODUCT||4||39|
|related question to modify VBA, how to get it from workbooks instead of worksheets||6||17|
|Excel VLOOKUP. How to return "Not Found" if Item or Qty is missing in Lookup table?||11||37|
|And OR formula||5||20|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!