Home > Forum Home > Excel Portfolio Optimization Template > Customizing the model :another query ? Share

Customizing the model :another query ?

Excel Help for Customizing The Model :another Query ? in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

Customizing The Model :another Query ?

Rate this:
(3/5 from 1 vote)
ConfusedHi ,

Thanks for your reply. I am trying to delete rows through macro but it gives an error "delete method of range class failed" when i used the following statement in my macro. Is it because the worksheet is locked ?

Here NxtID can be any row , say row 30 and "C" column is the date column

Sheets("Input").Cells(NxtID, "C").EntireRow.Delete

Thanks for your patience but I just want to be sure that I can customize this model to meet my needs.

Best,
Hansy
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Happy
Rate this:
(3/5 from 1 vote)
Upon purchasing the template, you will receive the password to unlock cells, sheets, and the workbook to be able to make modifications to formats, and add new sheets etc. Since much of the functionality depends on the original workbook structure, modifications made are at the sole risk of the user.

The VBA code password is not released and the code has been protected to ensure the robustness of operation and for intellectual property purposes.

 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Customizing the model :another query ? in the