Hello all,
I am an engineering student currently working at an engineering firm until the end of the summer. At work I am asked to create a system so that progress can be reported more easily. The problem should be a fairly easy problem but I have some problems getting started with VBA.
To report the progress I want to create a CommandButton in excel which creates a table where the progress of several (sub)projects are shown. At my company we already have a tool which exports a excel file in which all the need data is shown (if filled in correctly by engineers and project managers). I would like to create a excel file where the data exported form the tool can be stored and a CommandButton which creates a table with the processed data is created.
- I understand that there are nicer ways to solve this problem but for now this is the simplest and quickest way to solve the problem. -
In university I have done some programming in Matlab, this where mathematical operations. Since i have only experience in Matlab I am used to working with scalars, vectors and matrices only. I have asked a colleague to help me get started and he explained a little bit about defining your variables. So I already have my workbook and worksheets defined correctly.
When I start writing my code I keep on bumping on some errors and even google cannot give me the correct answers. I will try to explain my problem as clearly as possible.
To be able to collect the data I need to create a range. Because the exported data can change the range needs to be variable.
This gives me the correct numbers of Row to use for my range, however I have trouble using this number as the limit of my range. I cannot find a way to use this a my range.![]()
Please Login or Register to view this content.
I now have defined H as a Value but I cannot use this in a function? Can't I use a Long variable?![]()
Please Login or Register to view this content.
I have been working on this single problem for two days and I seem to be not understanding something. I really like the whole programming thing and hope to understand VBA and create some usefull macros. I am forever grateful to who can help me get started.
Bookmarks